Forum Discussion

krupalibshah's avatar
krupalibshah
Contributor
9 years ago

Connecting to SQLMX

I am working on connecting to a SQLMX database using the JDBC connection. The connection is successful when I add the details in the JDBC account, but when I try to execute queries from the pipelin...
jdbc
krupalibshah's avatar
krupalibshah
Contributor
9 years ago

Yeah, but still got the same error.
It got solved, not sure how.

But now when I am trying to use the same insert query in different ways I get this error,

Content of Json generator:

[
{

    "ACTIONNAME": "Audit",
    "TRANSACTIONID": "536b983a-bb79-4a0f-afa7-6c3b4a8890b9",
    "ENTRYTIMESTAMP": "2017-08-10T08:37:22.882",
    "EXITTIMESTAMP": "2017-08-10T08:37:22.882",
    "SOURCESYSTEMNAME": "_sSName",
    "TARGETSYSTEMNAME": "_tSName",
    "PIPELINEPROJECT": "PipelineProject",
    "PARENTPIPELINENAME": "_parentPipelineName",
    "CHILDPIPELINENAME": "_childPipelineName",
    "ASSOCIATEDPIPELINE": "_associatedPipeLines",
    "USERNAME": "_userId",
    "SNAPLEXNAME": "SnaplexName",
    "PARENTPIPELINEINSTANCEID": "_parentPipelineInstanceID",
    "CHILDPIPELINEINSTANCEID": "_childPipelineInstanceId",
    "BATCHID": "_batchID",
    "BUSINESSID": "_businessID",
    "STATUS": "_status"
}

]

Output of Mapper1 where we are getting error

Output of Mapper2 where it runs fine