missing expression error while running ODI Interface.

Scenario:
Sometimes when ODI interface is run, we may encounter an error like below

Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

If we check the code, it generates a code like below

 select 1 from APPS.MTH_ORGANIZATIONS_L T

where  

and ((T.ORGANIZATION_NAME = S.ORGANIZATION_NAME) )

here after WHERE there should have been (1=1) followed by AND condition.

Reason:

This occurs if none of the target columns have been defined as a key.

Solution:

Make one of the columns in the target table as Key by check the box. Now run the interface again. It should solve the issue.

Change Password of BISystemUser

Changing a password of BISystem user involves two steps.

1. Change password in /console
2. Change password in /em.

Change password in /console

1. Stop the system components in Enterprise Manager.

Click on Business Intelligence >Core application> Availability

 

 

2. Log into Weblogic Console and change the BISystemUser password.

Click on security realms > myreams > user and group

 

BISystemUser > Passwords

 

 

 

Change password in /em

3. Change password in EM:

Weblogic Domain > right click on bifoundation_domain > Security > Credentials > oracle.bi.system > system.user > Edit > change the password

 

 

4. Start BI System components from Enterprise Manager.

Click on Business Intelligence >Core application> Availability

5. Wait for 10 mins

6. Try the new password in the OBIEE URL.

Weblogic Domain Creation Fails due to PermGen Space Error OBIEE 11.1.1.6.0

During installation of OBIEE 11.1.1.6.0 on Windows Server 2008 - 64bit, it failed at the Domain Creation Step(Step 13 of 14) with the below error code

Creating a new AdminServer Object ...

 AdminServer port is 7001 Starting the domain ...

 java.lang.OutOfMemoryError: PermGen space
 java.lang.OutOfMemoryError: PermGen space
 java.lang.OutOfMemoryError: PermGen space

Reason:
This occurs due to insufficient runtime memory to JAVA during installation.

Solution:
This can be avoided by modifying the ORAPARAM.ini file in installer location like below.
D:\bishiphome\Disk1\install\win64\ORAPARAM.ini

Add the below line
JRE_MEMORY_OPTIONS=" -mx1024m -XX:MaxPermSize=1024m"

First make a clean uninstall of the entire OBIEE including the files from the directories.
Then restart the installation

Now during the installtion, at the stage when OneOff Patches are being installed(Step 12 of 14), make a modification to the ORAPARAM.ini parameter in the installed location like below.
D:\OBIEEMIDDLEWARE\Oracle_BI1\oui\ORAPARAM.ini

Add the same line specified above.

This would be helping in allocating sufficient memory to JAVA when
D:\OBIEEMIDDLEWARE\Oracle_BI1\bin\config.bat file is run during next step(Step 13 of 14)

Default Users Setup in OBIEE 11.1.1.6.0

Default Users Setup that comes with OBIEE 11.1.1.6.0

User	Groups
BISystemUser	Administrators
Weblogic	Administrators
	BIAdministrators
OracleSystemUser	OracleSystemGroup

Default Application Role Setup OBIEE 11.1.1.6.0

The below table represents the default setup of Application Roles. This is just to revert your settings just in case we end up corrupting the Setup.

Default Application Role Setup.

Role Name	Display Name	Principal	Type
BISystem	BI System Role	BISystemUser	User
BIAdministrator	BI Administrator Role	BIAdministrators	Group
BIAuthor	BI Author Role	BIAuthors	Group
		BIAdministrator	Application Role
BIConsumer	BI Consumer Role	BIConsumers	Group
		BIAuthor	Application Role
		Authenticated-user	Authenticated Role