openDocument fails because of unknown field name error

[Former Member]

Hi,

I am trying to execute reports on the server. The reports contain records filters and formulas which are necessary and cannot be removed. When I attempt to open a report with the openDocument function the application throws an error, that the field name is not known.

Both reports work fine when I execute them directly via the BO Central Management Console.

I hope, anybody can help me?

Thanks in advance.

IReportAppFactory reportAppFactory = (IReportAppFactory) eSession
					.getService("RASReportFactory");
			reportClientDocument = reportAppFactory.openDocument(infoObject, 0,
					java.util.Locale.getDefault());

Cannot open report document. --- This field name is not known.
Details: errorKind
Error in File {...}.rpt:
Error in formula  Record Selection: 
'my filter
'
This field name is not known.
Details: errorKind

The exception originally thrown was com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: This field name is not known.
Error in File {...}.rpt:
Error in formula ' my formula '
This field name is not known.
Details: errorKind---- Error code:-2147217383 Error code name:formulaParseError
at com.crystaldecisions.sdk.occa.managedreports.ras.internal.RASReportAppFactory.a(Unknown Source)
        at com.crystaldecisions.sdk.occa.managedreports.ras.internal.RASReportAppFactory.a(Unknown Source)
    at com.crystaldecisions.sdk.occa.managedreports.ras.internal.RASReportAppFactory.openDocument(Unknown Source)

...

[aasavaribhave]

is the report based on a command object or table\stored proc, also Are you trying to use custom DB logon configure in CMC? There is a similar issue escalated to product and to be fixed in Xi 3.1 SP5. I assuem if you remove the forumula it works fine, correct?

The reason it works fine in CMC is because it does not use RAS server.

[Former Member]

Hi,

thanks for your answer. The reports were build on a simple SQL statement and use custom DB logon in CMC.

I have created a similar report with no formulas or record filter. This new report works fine.

I also use user input parameters. I thought the problems depends on that these parameters are not set into

the implemented formulas and so the report cannot be parsed correctly.?

Do you have any additional information about the similar issue (only matter of interest)? Do you know if there are new JAR files released within this new version?

I hope the update will help. Thanks in advance.