Error during SQL execution

[former_member1327384]

Hi Experts,

We run a report which fails frequently with the below error. Could any one help me with the solution and reasons for this error.

Error during SQL execution: (DA0003): [Exception: DBD, ORA-01722: invalid number State: N/A] The following data providers have not been successfully refreshed: His. (DMA0007): []

Connection or SQL sentence error: (DA0005): [Exception: DBD, ORA-12535: TNS:operation timed out State: N/A] A connection required to refresh this document is unavailable. (DA0004): [] The following data providers have not been successfully refreshed: Reservations CW. (DMA0007): []

Many Thanks

Regards,

Syed

[arijit_das]

Is the report throwing error instantly or after running for some time?

This seems like the connection is timed out.

If the report is throwing the error instantly, then pls check with the db administrator if the user used in the universe connection is locked or not.

[former_member1327384]

Hi,

The report is running for long time and it's getting failed. could you please let me know what could be the reason for this?

And could you please tell me the reason/Solution for the first error which i mentioned before.

Many Thanks

Regards,

Syed

[former_member1327384]

Hi All,

Could any one please help me to sort out this Issue?

Regards,

Syed