RealTime Errors

CST-AOM-0016 A SAX error 'Invalid document structure' occurred while processing the request. I am getting this error while I am importing a new data source in FM

Solution: Actually I was installing FM in Program Files (x86), so I changed the locationof installation to Program Files and it is working.

Assignming different roles to diffeent users/ persons.

Solution: First assign administrators. Then if you want to assign the users in authors role, then add administrators (at least one) then remove 'everyone'. Now Administrator(s) are in authors role role. So now add the required staff as authors. Same is the case with Analytic users or whatever. 

Tables Dosn't Show Up While Importing in FM

Solution: I got to know from my experience that Excel, CSV cannot be used as a data source by itself to be imported to FM. It has to be through MS Access. 

I got this insight this way. 


In Function set of FM, there is no Excel or CSV but MS Access, so we have to import to Access and then import the metadata. 

No Read Permission on 'MSysRelationships' while importing data from MS Access.

Solution: This is how you have to deal with MS Access 2007 to give MSysRelationships. 


In Access 2007/2010, go to file-> options-> general->select blank database in 
here select 2003 at max or previous versions. 


On All Tables right click and select Tables and columns (something like this) and also system objects. 


Go to user permissions -> MSysRelationships then select/check Read Design and Read data options. 

BMT-MD-0003 UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled. 

UDA-SQL-0481 An expression or operator (case) is not supported by the database. This operation requires local processing of the data. 

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'. 

UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled. 

UDA-SQL-0481 An expression or operator (case) is not supported by the database. This operation requires local processing of the data. 

Solution: It clearly states that the operator or expression is not supported by the database. I am using MS Access, there is no 'contains' in MS Access. So is the error. Workaround is go to Data Source(s) in FM and in properties, change query processing to 'Limited local'

 The welcome screen in cognos is not being shown because I have checked it not to show the next time, I want it to be shown now.

Go to my preferences -> general-> check on 'show the welcome page at start up

CFG-ERR-0101 Unable to register IBM Cognos service.
Execution of the external process returns an error code value of '5'

Solution: I deleted the cogstartup.lock file and saved and restarted the Cognos configuration and its on. I didn't rename it. 

Also alternative,

Try renaming the service IBM Cognos to something like Cognos 10. You can do that in Cognos configuration under IBM Cognos Services -> IBM Cognos (right-click and rename) is a good solution.

Display Columns of list/ crosstab vertically

Solution:
Step: 1First unlock the report in Report Studio
Step 2: select the title of the column
Step 3: Go to Properties -> Text Flow and Justification -> Writing Model -> Top to Bottom, Left to Right
Step 4 : Ok