Error DA0003?

Hi
Any ideas on resolving this error?

Error during SQL execution: (DA0003)
The String representation of a datetime value is out of range.


sskchak (BOB member since 2004-06-21)

Can you give some detail where are you getting this error message? What are you trying to do when you got this error message?

kashif


Kashif Saeed :pakistan: (BOB member since 2004-06-02)

Most of the times when i got this error message it was either a connection problem (sometimes on 6.1a, the datasource name empties out itself from the connection) or it was taken care of by doing a Scan and Repair on security domain.

Try doing this, may be it would resolve your problem.

kashif


Kashif Saeed :pakistan: (BOB member since 2004-06-02)

I am getting this error message when I try to run a report with a prompt on date field at one of my client’s machine. But where as the same report works fine on my machine. Where as the client is able to access the universe and create adhoc reports. This is the same universe with which the reports were created.


sskchak (BOB member since 2004-06-21)

Hello,

I suspect this to a problem with the date format settings.
Please check the settings on your machine and the user’s machine.

Ashish


ashish_koul (BOB member since 2003-07-17)

Hi,

I compared my date settings with the client’s machine. Both look to be same. I compared in “regional options” in the control panel. Am I looking at the right place?. If yes, it doesn’t resolve the issue. I get this error only when I prompt for a date. It happens only at the client machine. When I try to input the date in the prompt field. it throws the above error.
Any ideas??


sskchak (BOB member since 2004-06-21)

Did you check the connection on the client machine?
I am quite sure it is a connection problem. If it is Full client, try defining the connection the same way it is defined under your machine’s SYstem DNS.
If it is webi, the connection on the server should be defined the same way as under your machine.

kashif


Kashif Saeed :pakistan: (BOB member since 2004-06-02)

Hi Kashif,
When the client logs in on the Infoview she gets the report to work. But with the full client and only for the reports which are prompted for date are prone to this error. I verified the client connection it seems to be same with all the parameters set.


sskchak (BOB member since 2004-06-21)