Forum Discussion

amardeep2021's avatar
amardeep2021
New Contributor III
4 years ago

Getting "error_code": 1207 while validating before loading Redshift database

Hi All, I am trying to load a new redshift table which I have created. While validation, I am getting “error_code”: 1207 “error_message”: "Invalid digit, Value ‘.’, Pos 9, Type: Integer " “co...
diff
jzhang1's avatar
jzhang1
New Contributor
7 years ago
Copy Link

can you share your code ? thank you a lot

walkerline117's avatar
walkerline117
Contributor
7 years ago
Copy Link

from com.snaplogic.scripting.language import ScriptHook
from com.snaplogic.scripting.language.ScriptHook import *
from subprocess import Popen, PIPE
import subprocess as subprocess

class TransformScript(ScriptHook):
def init(self, input, output, error, log):
self.input = input
self.output = output
self.error = error
self.log = log

def execute(self):
    self.log.info("Executing Transform script")
    proc = Popen(["ssh", "orsubdev@dev-server.com", " pwd "], shell=False, stdout=PIPE, stderr=PIPE)
    proc1 = Popen(["ssh", "orsubdev@dev-server.com", " 7za  x /dsdata/application/ORSUBDEV/CornerstoneLms/SourceFiles/testCasesSql.zip "], shell=False, stdout=PIPE, stderr=PIPE)
    out, err = proc.communicate()
    exitcode = proc.returncode
    proc.kill()
    self.output.write(out)
    self.log.info("Finished executing the Transform script")

hook = TransformScript(input, output, error, log)

  • mbowen's avatar
    mbowen
    Employee
    4 years ago
    Copy Link

    is annual_revenue an integer or a decimal? BIGINT will likely raise the same 1207 error trying to write a decimal value. It if should be an integer, then we should modify the pipeline to write this value as a integer.