Topic
  • 5 replies
  • Latest Post - ‏2013-07-09T15:43:08Z by GOICEHOCKEY
hockey
hockey
3 Posts

Pinned topic Time Based Partitioned Powerplay Cube Error Message

‏2011-08-29T17:51:55Z |
Good Afternoon ....

I can successfully build a time based cube which includes the .MDC, .VDC and folder with the time based .MDC files. When trying to open the cube in Analysis Studio, I receive the following error: Problem in the Time-based partitioned PowerCube definition file. Specify ppeLogFile in PowerPlay DataServer in .ini. (Virtual Cube)
From what I’ve read on this error, the directory pointers in the .VDC need to point to the directory folder containing the time based .MDC files. I’ve tried several different variations of putting the directory/folder name in the .VDC file, but I always get this error message. I’ve hit a wall and don’t know what else to try. If anyone has run into this and has conquered it, please let me know.

Thank U .....
Updated on 2011-10-03T17:17:28Z at 2011-10-03T17:17:28Z by hockey
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Time Based Partitioned Powerplay Cube Error Message

    ‏2011-08-29T22:17:39Z  
    There are examples of the vdc file syntax in the Transformer User Guide in the section "Customizing a Time-based Partitioned Cube". What is the actual path to the main mdc stub file, the vdc file, and the time partition mdc files you are trying to use? What options have you tried in the vdc file?

    Also, the vdc file should be created for you automatically when you do a full cube build. Does the cube work when you use the vdc file created through this process?
  • hockey
    hockey
    3 Posts

    Re: Time Based Partitioned Powerplay Cube Error Message

    ‏2011-09-07T13:17:52Z  
    There are examples of the vdc file syntax in the Transformer User Guide in the section "Customizing a Time-based Partitioned Cube". What is the actual path to the main mdc stub file, the vdc file, and the time partition mdc files you are trying to use? What options have you tried in the vdc file?

    Also, the vdc file should be created for you automatically when you do a full cube build. Does the cube work when you use the vdc file created through this process?
    Phil,

    Thank U for replying. I've tried the different syntax recommendations from the user guide, plus I've tried a few of my own. The files that are created automatically thru the transformer build process do not work. The server that the files get built on is an AIX box. Does that cause any kind of issue? I can build basic cubes (mdc files only) and >2G cubes (mdc and mdp files) and have no problems. It just seems to be with the time based folder file that gives me the problem.
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Time Based Partitioned Powerplay Cube Error Message

    ‏2011-09-07T22:16:00Z  
    • hockey
    • ‏2011-09-07T13:17:52Z
    Phil,

    Thank U for replying. I've tried the different syntax recommendations from the user guide, plus I've tried a few of my own. The files that are created automatically thru the transformer build process do not work. The server that the files get built on is an AIX box. Does that cause any kind of issue? I can build basic cubes (mdc files only) and >2G cubes (mdc and mdp files) and have no problems. It just seems to be with the time based folder file that gives me the problem.
    If the vdc file generated by the cube build does not work then you would be best to contact IBM support.

    To look for workarounds it would be good if you could provide the following information:

    1. The full path of the original files created during the cube build (list all the file names and their associated paths).
    2. The contents of the vdc file
    3. The full paths to the all the files when you are trying to publish/access the cube
  • hockey
    hockey
    3 Posts

    Re: Time Based Partitioned Powerplay Cube Error Message

    ‏2011-10-03T17:17:28Z  
    If the vdc file generated by the cube build does not work then you would be best to contact IBM support.

    To look for workarounds it would be good if you could provide the following information:

    1. The full path of the original files created during the cube build (list all the file names and their associated paths).
    2. The contents of the vdc file
    3. The full paths to the all the files when you are trying to publish/access the cube
    Phil W. Thank you for your help. We finally figured out the problem. When building the time based cube, it's final resting place was on an AIX server. The files were going through a Samba share which sent all the files over in binary which the .VDC file didn't like since it needed to be in ascii. Once we knew this we cleaned up the control characters in the .VDC file and now all is good with Analysis Studio.
  • GOICEHOCKEY
    GOICEHOCKEY
    135 Posts

    Re: Time Based Partitioned Powerplay Cube Error Message

    ‏2013-07-09T15:43:08Z  
    • hockey
    • ‏2011-10-03T17:17:28Z
    Phil W. Thank you for your help. We finally figured out the problem. When building the time based cube, it's final resting place was on an AIX server. The files were going through a Samba share which sent all the files over in binary which the .VDC file didn't like since it needed to be in ascii. Once we knew this we cleaned up the control characters in the .VDC file and now all is good with Analysis Studio.

    Hey, I know this was opened a long time ago but I am just giving it shut.

    I am stuck with the same problem moving files to a Linux box. How did you cleaned up the control characters?

    Thx a lot. Go Hockey!!