Hello all,
I'm using a protocol to select a big quantity (around 150 000) of structures through an ODBC connection. All those molecules are calcutated with various activities (number of ring, ...) and results are inserted in the database.
The problem is: if I select a small number of molecules everything is allright and insert are done as predicted. But for the big number of structures it seems thant insert are not well done.
If I choose a small group of molecule, they are inserted. But if this small group is within a larger group (150 000 structures), it seems that data are not processed?
Is there a way to trace behaviour of insertion?
Are there problems with ODBC within pipeline pilot with SQL select which gives a big result?
How can I create log files for the operations
Don't hesitate to ask for any further informations that can help you to understand the problem.
Thank you for your help.
Best Regards,
Jack
edit; I'm using the protocoles through a command line using xml export
as:
"C:\Program Files\SciTegic\bin\RunProtocol.exe" .\protocole1.xml -server mainserver -results .\res\results.log
I'm using a protocol to select a big quantity (around 150 000) of structures through an ODBC connection. All those molecules are calcutated with various activities (number of ring, ...) and results are inserted in the database.
The problem is: if I select a small number of molecules everything is allright and insert are done as predicted. But for the big number of structures it seems thant insert are not well done.
If I choose a small group of molecule, they are inserted. But if this small group is within a larger group (150 000 structures), it seems that data are not processed?
Is there a way to trace behaviour of insertion?
Are there problems with ODBC within pipeline pilot with SQL select which gives a big result?
How can I create log files for the operations
Don't hesitate to ask for any further informations that can help you to understand the problem.
Thank you for your help.
Best Regards,
Jack
edit; I'm using the protocoles through a command line using xml export
as:
"C:\Program Files\SciTegic\bin\RunProtocol.exe" .\protocole1.xml -server mainserver -results .\res\results.log