Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

DIH Server does not start with "Failure for DIH Staging database: [informatica][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied" error message
Problem Description
While starting DIH, it fails to start with below error:

INFO: Starting ProtocolHandler ["http-bio-19553"]
Instantiating local DX Server Bootstrap Core Context
2019-12-09 10:02:42,709 ERROR                    StagingRepositoryIntegrityCheckProcessor DIH staging database is configured, but content is not available
2019-12-09 10:02:42,709 ERROR                    StagingRepositoryIntegrityCheckProcessor Failure for DIH Staging database: [informatica][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied

2019-12-09 10:02:42,710 FATAL                    DXRuntimeControlImpl Fatal error in starting the services DIH Staging is not avaliable
Cause
This issue occurs if the database password is reset at the database side.
Solution
To resolve this issue, follow the below steps:

1. Get the current password for staging schema. This schema details can be found in dx-configuration.properties file by running below command:

cat dx-configuration.properties | grep  dih.staging.jdbc

Example output

dih.staging.jdbc.url=jdbc:informatica:oracle://host:1521;SID=orcl;
dih.staging.jdbc.username=test
dih.staging.jdbc.password=OCCXJJCQdQFfj6YJfb/N1g==
#dih.staging.jdbc.schema.name=${dih.staging.jdbc.schema.name}

2. Now, run dxpasswd.sh command to get the encrypted string of the password. This command is available in $DIHHOME/dx-tools/ directory.

Example

./dxpasswd.sh -p test
10:16:44 INFO  Default system locale: English (United States)
Encrypted string -->RnupdFmCwa3iCav6HCXamA==<--
Will decrypt to  -->test<--

3. Place the encrypted string of the password in dx-configuration.properties file which is present in below 2 locations:

* $DIH_HOME/conf and

* $DIH_HOME/tomcat/shared/classes


4. Now, start the DIH services.
More Information
​Below is the complete stack trace which can be found in dxserver-exception.log file:

2019-12-09 10:02:42,710                           FATAL [com.informatica.b2b.dx.bootstrap.DXRuntimeControlImpl] {main} Fatal error in starting the services
java.lang.RuntimeException: DIH Staging is not avaliable
        at com.informatica.b2b.dx.persistency.spring.StagingRepositoryIntegrityCheckProcessor.postProcessBeanFactory(StagingRepositoryIntegrityCheckProcessor.java:29)
        at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:281)
        at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:176)
        at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:687)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:525)
        at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
        at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:105)
        at com.informatica.b2b.dx.bootstrap.ServerAppContextManager.createAppContext(ServerAppContextManager.java:94)
        at com.informatica.b2b.dx.common.bootstrap.ApplicationContextManager.doCoreContextCreate(ApplicationContextManager.java:205)
        at com.informatica.b2b.dx.common.bootstrap.ApplicationContextManager.createCoreContext(ApplicationContextManager.java:168)
        at com.informatica.b2b.dx.common.bootstrap.ApplicationContextManager.createContexts(ApplicationContextManager.java:97)
        at com.informatica.b2b.dx.bootstrap.DXRuntimeControlImpl.start(DXRuntimeControlImpl.java:139)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:84)
        at com.informatica.b2b.dx.framework.rmi.IPWhiteListAcceptor.isAllowed(IPWhiteListAcceptor.java:92)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
        at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
        at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy4.start(Unknown Source)

Applies To
Product: Data Integration Hub
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:3/31/2020 3:13 AMID:609939
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)