BrianMH
07-01-2011, 01:09 AM
Hi,
The code in question is quite complex so I won't post it here. You may be able to help or give me an idea anyway.
I have code that imports data and does some queries with it in internal an external tables. Once it has done these queries and creates some tables it ouputs text files.
The problem is that on the first run it often doesn't output a particular text file. Then on the next run it does. Same data and code each time. I can't seem to reproduce this on demand. It seems random but more often on the first run.
edit: After posting this I thought it might be possible that tables are not being filled due to ocdb timeout. This may be the issue, although if you have any other ideas please feel free to post them.
Is there a simple way to loop through all the queries in the database and set them so they have no timeout value set?
The code in question is quite complex so I won't post it here. You may be able to help or give me an idea anyway.
I have code that imports data and does some queries with it in internal an external tables. Once it has done these queries and creates some tables it ouputs text files.
The problem is that on the first run it often doesn't output a particular text file. Then on the next run it does. Same data and code each time. I can't seem to reproduce this on demand. It seems random but more often on the first run.
edit: After posting this I thought it might be possible that tables are not being filled due to ocdb timeout. This may be the issue, although if you have any other ideas please feel free to post them.
Is there a simple way to loop through all the queries in the database and set them so they have no timeout value set?