LAE

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

Originally posted by: Rapkat

I am using a DB Query node, have set up the ODBC link etc. I can bring other queries from the same Database in the same way but not this particular query, I receive the error log below.
The output of the query contains 2 fields and 89 records, an example of the data:

GTCode Dependent
509LC00 509BC00




Installing log (03/26/2010 10:30:28) ...
2010-03-26 10:30:28; Level: 2; Type: 0; Desc: "unable to free statement handle"; File: "\src\brain_d\jigsaw\Code\Source\DB\ODBC\OdbcEnv.c pp"; Line: 352; Context: "OdbcEnv::FreeHandle(ctype)"
2010-03-26 10:30:28; Level: 2; Type: 0; Desc: "...exception seen"; File: "\src\brain_d\ra_dev\code\source\brain\DbNodeIo.cp p"; Line: 70; Context: "Salmon::NED::NodeIo::DbInput::DbInput()"
2010-03-26 10:30:28; Level: 2; Type: 0; Desc: "...exception seen"; File: "\src\brain_d\ra_dev\code\source\brain\QueryDumper \QueryDumperNodeControl.cpp"; Line: 125; Context: "Salmon::NED::QueryDumper::QueryDumperNodeControl: :createQueryInput()"
2010-03-26 10:30:28; Level: 2; Type: 0; Desc: "...exception seen"; File: "\src\brain_d\ra_dev\code\source\brain\QueryDumper \QueryDumperNodeControl.cpp"; Line: 99; Context: "Salmon::NED::QueryDumper::QueryDumperNodeControl: :initializeIo()"
Uninstalling log (03/26/2010 10:30:28) ...

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

Originally posted by: timonk

Rapkat,
Could you possibly post the query you are trying to run?
Thank you
Regards,
Timon Koufopoulos
MDA Support

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

Originally posted by: Rapkat

I have attached the BRE that contains 2 nodes that are pulling data from the same DB. Dependant Tariffs doesn't work but the Published Rates do.

I have also attached the ODBC setup and the data that I am trying to get for Dependant Tariffs.

Thanks.
Attachments:
Dependants DB Query.brg

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

Originally posted by: rboccuzzi

I believe you can only update certain file types, or possibly only one file. If you can zip all the files together, and upload that, it would be helpful.

Cheers
Rich