Thursday, July 14, 2016

Batchloader issue in oracle webcenter content

I am using Oracle webcenter content 11.1.1.7.0. To configure a JDBC Driver for standalone applications i ran DomainHome/ucm/cs/bin/SystemProperties and entered the details as follows
database driver classpath : /Integration/d02/app/oramdev/product/11.2.0/dbhome_1/jdbc/lib/ojdbc6.jar
jdbc driver name : oracle.jdbc.OracleDriver
jdbc connection string : jdbc:oracle:thin:@server2.yantro.com:1521/orcl.yantro.com
jdbc username : DEV_OCS
jdbc user password : schema password

then i ran ./BatchLoader and it throws the following error.

oramdev@server2 bin]$ ./BatchLoader
'DynamicConverter' component, version
'2013_01_16 (rev 23669) 11.1.7.6', require
s a missing feature. The feature
'ContentAccess' is not installed.
>componentloader/4 06.21
19:11:19.106 main !csComponentRequiresMiss
ingFeatures,DynamicConverter,2013_01_16 (rev 23669)
11.1.7.6,!syFeatureNotInstal
led\,ContentAccess\,\,0
>(internal)/3 06.21 19:11:31.953
main !$Unable to start the batch load
er.
(internal)/3 06.21 19:11:31.953
main at intradoc.common.Defau
ltTraceImplementor.appendStackTrace(DefaultTraceImplementor.java:327)
(internal)/3 06.21 19:11:31.953
main at intradoc.common.Defau
ltTraceImplementor.traceDumpException(DefaultTraceImplementor.java:446)
(internal)/3 06.21 19:11:31.953
main at intradoc.common.Defau
ltReportHandler.message(DefaultReportHandler.java:439)
(internal)/3 06.21 19:11:31.953
main at intradoc.common.Defau
ltReportDelegator.message(DefaultReportDelegator.java:140)
(internal)/3 06.21 19:11:31.953
main at intradoc.common.Repor
t.messageInternal(Report.java:172)
(internal)/3 06.21 19:11:31.953
main at intradoc.common.Repor
t.message(Report.java:154)
(internal)/3 06.21 19:11:31.953
main at intradoc.common.Repor
t.error(Report.java:427)
(internal)/3 06.21 19:11:31.953
main at BatchLoader.main(Batc
hLoader.java:104)
(internal)/3 06.21 19:11:31.953
main at sun.reflect.NativeMet
hodAccessorImpl.invoke0(Native Method)
(internal)/3 06.21 19:11:31.953
main at sun.reflect.NativeMet
hodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
(internal)/3 06.21 19:11:31.953
main at sun.reflect.Delegatin
gMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
(internal)/3 06.21 19:11:31.953
main at java.lang.reflect.Met
hod.invoke(Method.java:597)
(internal)/3 06.21 19:11:31.953
main at intradoc.loader.IdcCl
assLoader.invokeMain(IdcClassLoader.java:352)
(internal)/3 06.21 19:11:31.953
main at intradoc.loader.IdcCl
assLoader.startMain(IdcClassLoader.java:170)
(internal)/3 06.21 19:11:31.953
main at intradoc.loader.IdcCl
assLoader.main(IdcClassLoader.java:140)
(internal)/3 06.21 19:11:31.953
main Caused by: intradoc.data.DataExc
eption: !apFailedToInitialize
(internal)/3 06.21 19:11:31.953
main at intradoc.apps.shared.
AppLauncher.init(AppLauncher.java:252)
(internal)/3 06.21 19:11:31.953
main at BatchLoader.main(Batc
hLoader.java:82)
(internal)/3 06.21 19:11:31.953
main ... 7 more
(internal)/3 06.21 19:11:31.953
main Caused by: intradoc.common.Servi
ceException:
!csProviderUnableToInitialize,SystemDatabase
(internal)/3 06.21 19:11:31.953
main at intradoc.server.IdcSy
stemLoader.loadProviders(IdcSystemLoader.java:2371)
(internal)/3 06.21 19:11:31.953
main at intradoc.server.IdcSy
stemLoader.initProviders(IdcSystemLoader.java:2124)
(internal)/3 06.21 19:11:31.953
main at intradoc.server.IdcSy
stemLoader.finishInit(IdcSystemLoader.java:400)
(internal)/3 06.21 19:11:31.953
main at intradoc.server.IdcSy
stemLoader.init(IdcSystemLoader.java:335)
(internal)/3 06.21 19:11:31.953
main at intradoc.apps.shared.
StandAloneApp.initSystem(StandAloneApp.java:277)
(internal)/3 06.21 19:11:31.953
main at intradoc.apps.shared.
StandAloneApp.init(StandAloneApp.java:112)
(internal)/3 06.21 19:11:31.953
main at intradoc.apps.shared.
AppLauncher.init(AppLauncher.java:234)
(internal)/3 06.21 19:11:31.953
main ... 8 more
(internal)/3 06.21 19:11:31.953
main Caused by: intradoc.data.DataExc
eption:
!csJdbcUnableToCreateConnection,SystemDatabase,jdbc:oracle:thin:@server2
.yantro.com:1521/orcl.yantro.com
(internal)/3 06.21 19:11:31.953
main at intradoc.jdbc.JdbcCon
nectionUtils.getConnection(JdbcConnectionUtils.java:123)
(internal)/3 06.21 19:11:31.953
main at intradoc.jdbc.JdbcWor
kspace.init(JdbcWorkspace.java:84)
(internal)/3 06.21 19:11:31.953
main at intradoc.provider.Pro
vider.init(Provider.java:71)
(internal)/3 06.21 19:11:31.953
main at intradoc.server.IdcSy
stemLoader.loadProviders(IdcSystemLoader.java:2361)
(internal)/3 06.21 19:11:31.953
main ... 14 more
(internal)/3 06.21 19:11:31.953
main Caused by: java.sql.SQLException
: ORA-01017: invalid username/password;
logon denied
(internal)/3 06.21 19:11:31.953
main
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIoer.processError(T4CTTIoer.java:445)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIoer.processError(T4CTTIoer.java:389)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIoer.processError(T4CTTIoer.java:382)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIfun.processError(T4CTTIfun.java:600)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIfun.receive(T4CTTIfun.java:450)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIfun.doRPC(T4CTTIfun.java:192)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CConnection.logon(T4CConnection.java:401)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.Ph
ysicalConnection.<init>(PhysicalConnection.java:546)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CConnection.<init>(T4CConnection.java:236)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.T4
CDriverExtension.getConnection(T4CDriverExtension.java:32)
(internal)/3 06.21 19:11:31.953
main at oracle.jdbc.driver.Or
acleDriver.connect(OracleDriver.java:521)
(internal)/3 06.21 19:11:31.953
main at java.sql.DriverManage
r.getConnection(DriverManager.java:582)
(internal)/3 06.21 19:11:31.953
main at java.sql.DriverManage
r.getConnection(DriverManager.java:154)
(internal)/3 06.21 19:11:31.953
main at intradoc.jdbc.JdbcCon
nectionUtils.getConnection(JdbcConnectionUtils.java:107)
(internal)/3 06.21 19:11:31.953
main ... 17 more

and moreover it shows the following
uanble to start batch loader. Failed to initialize.unable to initialize the system provider 'systemdatabase'. Unable to create the database connection for the 'systemdatabase' with connection string
'jdbc:oracle:thin:@server2.yantro.com:1521/orcl.yantro.com'. Please make sure that the connection string,user and password are correct.
java.sql.SQLException:ORA-01017:invalid username/password;login denied

Main issue here is : !csProviderUnableToInitialize,SystemDatabase and the steps to solve the issue are

1. Navigate to <domain_home>/ucm/cs/bin/SystemProperties applet

2. Navigate to database tab and select the Oracle Thin Driver

3. leave the classpath field blank

4. For the db connection , provide the db host name , port and service name details

5. Set the UCM schema user id and password and update

6. Run these 2 sql queries on UCM DB schema :

update users set dpasswordencoding='' where dname like 'sysadmin';

update users set dpassword='idc' where dname like 'sysadmin';

7. Then launch BatchLoader and verify it works fine .
 

No comments:

Post a Comment

IAS Cache initialization failed

 Today I faced an Issue in R12.2 instance. The solution I followed to overcome the issue is very simple, but they are more than one solution...