Error with windows vista but not xp

[Former Member]

Hi there all,

IT have recently changed my computer to Windows Vista from XP.

i have lots of reports that were created pre transfer and they now dont work in vista.

it seems to be a common problem when a report containts "Date Job completed" it returns an error of "ERROR DURING SQL EXECUTION DA0003" so i assumed it must be a time out error and ameded the times in regedit.

however it still doesnt work. i cant see it being a date format as a simple report that contains "date job raised" works. its just these other date ones!

can anyone shed any light on the problem im experiencing? IT have now given me my old computer back to fix the problem but im gonna need to go back to the new one again soon!!

also, i assume it must be a setting somewhere that needs changing!?!?

thank you

sam

p.s. i use desktop intelligence XIR2.

[Former Member · Accepted solution]

Hi Samantha,

Are you getting the error message while accessing deski through infoview or just local deski.

If it is deski through infoview, Can you please let me know which version of Internet Explorer you are using.

You can try the below steps to increase the timeout of IE in your machine and then test the report.

Now, here are the steps to increase the IE7 timeout-

Backup of your registry settings, before making any changes.

Add a ReceiveTimeout DWORD value with a data value of (<number of seconds>)*1000 in the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings

For example, if you want the timeout duration to be 8 minutes, set the ReceiveTimeout data value to 480000 (<480>*1000).

Restart your computer.

Repeat all of the above steps on every computer that uses IE 7.

This particular error message appears because of the Timeout setting in Microsoft Internet Explorer 7. By default, IE 7 has the timeout of 30 seconds.

Also, here is the link from Microsoft which identifies the issue-

http://support.microsoft.com/kb/181050/en-us

Lets hope this resolves your issue.

Regards,

Gaurav

[Former Member · Accepted solution]

Hi Gaurav,

Thank you for your input however ive changed the time out settings already.......and restarted etc and it didnt resolve the issue.

its when i access desktop intelligence xir2 on its own or through infor view.

it works with some parts but not others.

"date job completed" seems to be a problem, it wont let me apply a condition with it to run the report but it will return the data if i add it in the report.

thanks

sam

[Former Member · Accepted solution]

Hi Samanth,

Could you please delete user prefrences in the registry and login into deski to rebuild again.

It seems to be the problem with installation.

Also could you please make the new connection from the scratch and test the issue.

Regards,

Sarbhjeet Kaur

[Former Member · Accepted solution]

Hi Sam,

Can you please tell me the exact error message, after the message i.e. ERROR DURING SQL EXECUTION DA0003 , you must be getting some other message also.

And also what is the definition of the date object in the designer?

Regards,

Gaurav

[Former Member · Accepted solution]

Hiya,

it is error message "ERROR DURING SQL EXECUTION DA0003 cs job already in use"

the date is merely just pulled from a live database along with all the other dates......

thanks

Sam