?
Solved

Cognos - Create PowerCube

Posted on 2008-06-26
9
Medium Priority
?
1,123 Views
Last Modified: 2013-11-24
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?

0
Comment
Question by:hoikar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 12

Expert Comment

by:RWrigley
ID: 21874900
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
 

Author Comment

by:hoikar
ID: 21880401
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
 
LVL 12

Accepted Solution

by:
RWrigley earned 375 total points
ID: 21883082
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:hoikar
ID: 21896140
which DLL files, please specify...Many Thanks~
0
 

Author Comment

by:hoikar
ID: 21896142
I install the ver 7.4 in different machine, separate from ver 6.5
0
 
LVL 12

Expert Comment

by:RWrigley
ID: 21898523
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
 

Author Comment

by:hoikar
ID: 21912849
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
 

Author Comment

by:hoikar
ID: 21912876
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
 

Author Closing Comment

by:hoikar
ID: 31470883
I am still suffering in this problem
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question