Sage X3 Intelligence Reporting : An unexpected error occurred. Error Number : [3704]. Description : [Operation is not allowed when the object is closed.]. Source : [ADODB.Recordset]

Hi All

I get the following error when running reports that I created using stored procedure containers:

Sage X3 Intelligence Reporting : An unexpected error occurred.

Error Number : [3704]

Description : [Operation is not allowed when the object is closed.]

Source : [ADODB.Recordset]

Further information:

1. I get the error on all my schemas

2. There is one report that does use a simple stored proc without parameters that runs without an issue

3. I get the error as soon as I've entered parameters and select OK

4. I've checked a previous post with a similar error and checked what was suggested

Michael

Views: 42

Attachments:

Reply to This

Replies to This Discussion

Good day,

I have found this article hope it helps:

http://kb.sageintelligence.com/index.php?title=Error:_Problem_Rende...

Helen

Thanks, I'll check it out

I found the follwing solution to this issue. It may not have resolved the source problem, and may just be a work around:

I went and changed all the lists on the parameters where I was listing text by adding apostrophes as prefixes and suffixes to the options in the list:

So E.g. Parameter Company - List option was Company1, Company2

I changed this to 'Company1', 'Company2'

This resolved my issue

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service