LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Insert data into netezza database.

    Employee
    Posted 03-06-2008 04:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: senthilnathan

    Greetings All,
    I am new to Lavastorm. I have created a simple mapping to move data from a dat file to a table in the netezza or oracle. I get the following error.
    How to establish the connectivity from lavastorm to netezza or oracle?

    09:55:36 - Assigned Node "DB Store" ("47ce97292be46e23") on localhost:7721#1
    09:55:36 >>Msg: PROCESSING from localhost:7721#1
    >>
    09:55:36 - PROCESSING - Server localhost:7721#1 is active
    09:55:36 >>Msg: NODEPROC from localhost:7721#1
    >> node:47ce97292be46e23
    >> where:local
    >>
    09:55:36 - Processing Node "DB Store" ("47ce97292be46e23") on localhost:7721#1
    writing brs file F:\\BrainScratch\\BRE\\bak\\F%c-BrainScratch-BRE-brs@cityINst_run47ce9b050d20716c.brs.autosave
    09:55:38 >>Msg: ERROR from localhost:7721#1
    >> Msg:<<EOM416891091
    >> ERROR opening i/o streams:
    >> unknown exception caught in main()
    >> EOM416891091
    >g: ERROR from localhost:7721#1
    >> msg:Error while starting execution of node 'DB+Store'
    >> msg:Error executing node: Process exited before ENDIO message received.
    >> node:47ce97292be46e23
    >> name:DB+Store
    >>
    09:55:38 - ERROR Processing Node "DB Store" ("47ce97292be46e2re ENDIO message received.
    09:55:38 >>Msg: NODEDONE from localhost:7721#1
    >> result:1
    >> node:47ce97292be46e23
    >> startTimeMillis:1204777536348
    >> endTimeMillis:1204777538493
    >> output:47ce97292be46e23.ErroredData
    >> errlogfile:file:F:\\Br
    >> errlog:2008-03-06 09:55:38; Level: 2; Type: 0; Desc: "Error allocating error handle"; File: "\\src\\brain_c\\jigsaw\\Code\\Source\\Oci\\OciEnv .cpp"; Line: 120; Context: "OciEnv::AllocateErrorHandle()"
    >> errlog:2008-03-06 09:55:38; Level: 2; Type: 0; Desc: "...exception seen"; File: "\\src2008-03-06 09:55:38; Level: 2; Type: 0; Desc: "...exception seen"; File: "\\src\\brain_c\\ra_dev\\code\\source\\brain\\DbNo deIo.cpp"; Line: 116; Context: "Salmon::NED::NodeIo::DbOutput::DbOutp
    ut()"
    >> errlog:2008-03-06 09:55:38; Level: 2; Type: 0; Desc: "...exception seen"; File: "\\src\\brain_c\\ra_dev\\code\\source\\brain\\Node Io.cpp"; Line: 219; Context: "Salmon::NED::NodeIo::Output::createOutput()
    "
    >> errlog:2008-03-06 09:55:38; Level: 2; Type: 0; Desc: "...exception seen"; File: "\\src: "...exception seen"; File: "\\src\\brain_c\\ra_dev\\code\\source\\brain\\Node Control.cpp"; Line: 743; Context: "Salmon::NED::NodeControl::initializeIo()"
    >> errlog:2008-03-06 09:55:38; Level: 2; Type: 0; Desc: "...exception seen"; File: "\\src\\brain_c\\ra_dev\\code\\source\\brain\\DBLo ader\\DBLoaderNodeControl.cpp"; Line: 148; Context: "Salmon::NED::DBL
    oader::DBLoaderNodeControl::initializeIo()"
    >> errlog:Uninstalling log (03/06/2008 09:55:38) ...
    >>
    09:55:38 - DONE Processing Node "DB Store" ("47ce97292be46e23") - result code is 1 on localhost:7721#1- Last execution 2.11 seconds
    09:55:38 >>Msg: DONE fDONE - Server localhost:7721#1 is idle - Last execution 2.13 seconds
    *****

    Regards


  • 2.  RE: Insert data into netezza database.

    Employee
    Posted 03-12-2008 20:09

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    I need more information, but from what I can see, you are not properly connecting with your oracle installation. Is oracle client properly installed on your system? What version of oracle is installed? Is it possible the registry settings for oracle have been munged? Can you TNSPING the service from a cmd shell?