[Solved] Cognos 10.2.1 64-bit upgrade question

[Steve]

Hi All -

We upgraded our system from 10.1.1 32-bit  to 10.2.1 64-bit . The backend is AS 400 and the
connection uses ODBC. The content migrated but some reports which have cognos functions like 'cast' , 'running count' etc are erroring out saying that it requires local processing which is not enabled. The data source in FM is set to 'Database Only' processing but that's how it was in 10.1.1. and it is working there.  My understanding is that Cognos is supposed to detect the
database and generate the appropriate SQL using the syntax/command that is acceptable to the DB. So why is it giving this
error now? Does it require JDBC instead of ODBC?  These packages are not using DQM.

Anybody experienced this ?

Thanks

[Ammus1234]

Hello,

I have upgraded from 32 to 64 bit. I was not able to run any reports and getting below error.

"This report service is configured as 64-bit and only supports packages published with the dynamic query mode."

The packages enabled with dqm only works for me. My backend DB is SQL server 2008 R2.

[Grim]

Hi All -

We upgraded our system from 10.1.1 32-bit  to 10.2.1 64-bit . The backend is AS 400 and the
connection uses ODBC. The content migrated but some reports which have cognos functions like 'cast' , 'running count' etc are erroring out saying that it requires local processing which is not enabled. The data source in FM is set to 'Database Only' processing but that's how it was in 10.1.1. and it is working there.  My understanding is that Cognos is supposed to detect the
database and generate the appropriate SQL using the syntax/command that is acceptable to the DB. So why is it giving this
error now? Does it require JDBC instead of ODBC?  These packages are not using DQM.

Anybody experienced this ?

Thanks

Are you using the same ODBC driver and is it 32bit?

[Grim]

Hello,

I have upgraded from 32 to 64 bit. I was not able to run any reports and getting below error.

"This report service is configured as 64-bit and only supports packages published with the dynamic query mode."

The packages enabled with dqm only works for me. My backend DB is SQL server 2008 R2.

This should be a new post as it has nothing to do with the OP.

[Steve]

Are you using the same ODBC driver and is it 32bit?

I think you hit the goal Grim !  That might be the reason !

I created a FM Model to work with SQL Server DB and set the processing to 'Database Only', then created a report using the same functions and it works ! SQL Server doesn't need ODBC ! So probably ODBC is the reason for AS 400!

Thanks again Grim ! Appreciate it !

[Grim]

Awesome. Happy to help.

Edit your OP and add {Resolved] or [Solved] to the title.

[MFGF]

Hello,

I have upgraded from 32 to 64 bit. I was not able to run any reports and getting below error.

"This report service is configured as 64-bit and only supports packages published with the dynamic query mode."

The packages enabled with dqm only works for me. My backend DB is SQL server 2008 R2.

Change the configuration so that your report service is 32 bit. You can only run reports based on DQM packages if you set the Report Service to 64 bit (as it disables CQM).

MF.

[Ammus1234]

Thanks MF. I am planning to update the packages with DQM.