Cognos - Create PowerCube

My company new using 2 different version to generating Powercube with transform - TRNSFRMR command.

My db (dbase) totally have 270 columns. it is okie if I using transformer 6.5 to create power cube but error message: cannot open the .dbf file (too many fields defined) if I use transformer 7.4

anyone could help to solve this problem?
and also may I know the max no. of column could use in transformer 7.4 in order to generate cubes?

hoikarAsked:
Who is Participating?
 
RWrigleyCommented:
Is your 7.4 installed on the same machine as your 6.5?  This error is usually caused by a bad/older database driver, although I've seen it occur if some of the Transformer DLL's weren't upgraded correctly.  
0
 
RWrigleyCommented:
I've never seen that error before, and I suspect its coming from the database client, not Transformer itself.  Can you post the output of your transformer build showing the error?
0
 
hoikarAuthor Commented:
I have tried to eliminate the no. of column to 255 and it's ok, is it because cognos ver 7.4 cannot support database with more than 255 cols? any suggestion to fix this?? and why no problem if I using ver 6.5 ??

Attached the error message to you for your reference
screen.bmp
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
hoikarAuthor Commented:
which DLL files, please specify...Many Thanks~
0
 
hoikarAuthor Commented:
I install the ver 7.4 in different machine, separate from ver 6.5
0
 
RWrigleyCommented:
Could be a number of them.  Here's a common one; compare the version with your 6.5 machine.

And as a test, try installing 7.4 on the same machine as your 6.5 (they go into different directories, so they shouldn't conflict with one another)

C:\program files\common files\microsoft shared\DAO\DAO350.DLL
0
 
hoikarAuthor Commented:
I have tried but got the some problem
BTW, the version in C:\program files\common files\microsoft shared\DAO\DAO350.DLL is "3.51.1608.0"
anything I could do next?

Thanks
0
 
hoikarAuthor Commented:
I had found that 2 file: dao360.dll (3.60.8618.0) and dao350.dll (3.51.1608.0) exist in this path
C:\program files\common files\microsoft shared\DAO\
which one should be the one suit this upgrade?

Thanks
0
 
hoikarAuthor Commented:
I am still suffering in this problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.