PDA

View Full Version : error while designing report



j123
09-13-2006, 11:17 PM
Hi
I am very badly stucked while designing the report. As I am using ms sql server as my database and I was using report design to design my report. Oh I wanted to design the mdx olap. But before that I was testing the example which was given in the pentaho. So I migrated the data to my ms sql server and then did the database connection as follows:
MDX_Datasource.xaction
[CDATA[jdbc:jtds:sqlserver://128.0.1.200:1433/SampleData? user=pentaho_user & password=password]

I got the following error:
Failed
--------------------------------------------------------------------------------

Error: MDXBaseComponent.ERROR_0006 - Could not execute
MDX_Datasource.xaction - java.lang.NullPointerException
(org.pentaho.plugin.mdx.MDXLookupRule)
Debug: Starting execute of samples/datasources/MDX_Datasource.xaction
(org.pentaho.core.solution.SolutionEngine)
Debug: Getting runtime context and data
(org.pentaho.core.solution.SolutionEngine)
Debug: Loading action sequence definition file
(org.pentaho.core.solution.SolutionEngine)
Debug: SolutionRepository.DEBUG_FILE_PATH - getFile
path=C:\\pentaho1\\pentaho-demo\\pentaho-solutions\\samples\\datasources\\MDX_Datasource.xaction
(org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: audit: instanceId=79f3f065-42c2-11db-bd63-e9f1a712f8db,
objectId=org.pentaho.core.runtime.RuntimeContext,
messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
Debug: validateComponent validating component MDXLookupRule
(org.pentaho.core.runtime.RuntimeContext)
Debug: Validating component for action MDX_Datasource.xaction
(org.pentaho.plugin.mdx.MDXLookupRule)
Debug: Executing action sequence
(org.pentaho.core.runtime.RuntimeContext)
Debug: Executing action definition: Iteration 0
(org.pentaho.core.runtime.RuntimeContext)
Debug: audit: instanceId=79f3f065-42c2-11db-bd63-e9f1a712f8db,
objectId=MDXLookupRule, messageType=component_execution_started
(org.pentaho.core.runtime.RuntimeContext)
Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
Debug: Setting component log level to DEBUG
(org.pentaho.core.runtime.RuntimeContext)
Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
Debug: executeComponent starting audited execute
(org.pentaho.core.runtime.RuntimeContext)
Debug: execute validation=true (org.pentaho.plugin.mdx.MDXLookupRule)
Error: MDXBaseComponent.ERROR_0006 - Could not execute
MDX_Datasource.xaction - java.lang.NullPointerException
(org.pentaho.plugin.mdx.MDXLookupRule)
Debug: executeComponent finished audited execute
(org.pentaho.core.runtime.RuntimeContext)
Error: RuntimeContext.ERROR_0012 - ActionDefinition for MDXLookupRule
did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
Debug: audit: instanceId=79f3f065-42c2-11db-bd63-e9f1a712f8db,
objectId=org.pentaho.core.runtime.RuntimeContext,
messageType=action_sequence_failed (org.pentaho.core.runtime.RuntimeContext)
Error: SolutionEngine.ERROR_0007 - Action sequence execution failed
(org.pentaho.core.solution.SolutionEngine)



Server Version 1.2.RC1.0 build 341
Please I really need assistance on this coz I have to design a report. One thing I also want to mentioned that I also tried with jfreereport it still got the same error.
Like I have to assign the database user and password to the database in ms sql server but can anyone guide me how to do that as the database defalt owner comes as owner. Is something to do with that to solve this problem.
I am just frustrated with it. If you require further more details then pleaede let me know. If possible can email me joti.chand@gmail.com
please...please.............

Looking forward for the assistance!!!!!

joti

mdamour
09-14-2006, 07:45 AM
Joti-

Are you using the Report Designer or the Report Design Wizard?

Stay with it, we'll get through this. :)

-Mike

j123
09-14-2006, 01:27 PM
Hi Mike,

Firstly I tried with pentaho-report-design-wizard 1.2. My jndi connection was sucess whereas my designer was fine but when I tried to peview my report it gave the java.lang.NullPointerException error. It didnt worked for me so I went to next option which was pentaho-design-studio-1.2 RC1.193. With this I wanted to create the olap using MDX. What I did was I migrated the database from hibernate to my ms sql server and then all the connections which was pointing to hibernate I updated to ms sql server. But when I tested it to error was given as I posted it earlier.
I did the odbc connection as it was mentioned in one of the document. I did read the documents and also went to the forums but I need help very badly.

Hope sir you can guide me through.
Looking forward for your kind cooperation. I really want to use pentaho.
thanks
joti