Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..
298 views

AMGenericAdapter - Error while parsing date [2016-01-01]

AM 9.6

AMGenericAdapter v1.02

UCMDB 10.31

When populating contract from AM, I keep getting the following error.  The error specify a contract start date (dStart). Any idea how to resolve this error?

2017-01-09 16:13:17,437  ERROR  [JobExecuterWorker-0:DS_AM Generic test_2 Financial Base CI] - 	!!!	Operation	Data Access Adapter Query: Retrieve Changed Data()	ID:	165455126	FAILED (running time:	3048 ms[ms])
com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException: [ErrorCode [802] General Integration Error{AM Generic test}]
java.lang.RuntimeException: Error while parsing date [2016-01-01]
	at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessGeneralException(ExceptionConverter.java:341)
	at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:175)
	at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:67)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.createAdapterAccessException(AbstractDataAccessAdapterOperation.java:54)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:39)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:87)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:60)
	at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
	at com.mercury.topaz.cmdb.shared.manage.operation.flow.OperationInFlowDefaultExecutor.execute(OperationInFlowDefaultExecutor.java:23)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:158)
	at com.hp.ucmdb.dataAccess.manager.DataAccessAdapterManagerProbeImpl.executeOperation(DataAccessAdapterManagerProbeImpl.java:50)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.adapters.DataAccessAdaptersFacade.invokeOperation(DataAccessAdaptersFacade.java:396)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runChangesOnPopulateChangesAdapter(AdapterService.java:1293)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueriesOnPopulateChangesAdapter(AdapterService.java:1130)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueries(AdapterService.java:358)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runDiscovery(AdapterService.java:202)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.discover(AdapterService.java:150)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter.launchTask(JobExecuter.java:1206)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.launchAndIsProbeRestarting(JobExecuter.java:953)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.executeTask(JobExecuter.java:869)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.run(JobExecuter.java:729)
Caused by: com.hp.amadapter.population.AMAdapterException: java.lang.RuntimeException: Error while parsing date [2016-01-01]
	at com.hp.amadapter.AMPopulationAdapter.populate(AMPopulationAdapter.java:86)
	at com.hp.ucmdb.adapters.GenericAdapter.getChanges(GenericAdapter.java:1039)
	at com.hp.ucmdb.dataAccess.operations.DataAccessAdapterQueryRetrieveChanges.getChangesResult(DataAccessAdapterQueryRetrieveChanges.java:50)
	at com.hp.ucmdb.dataAccess.operations.DataAccessAdapterQueryRetrieveChanges.doDataAccessQueryExecute(DataAccessAdapterQueryRetrieveChanges.java:38)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessLifeCycleAdapterQuery.doLifeCycleExecute(AbstractDataAccessLifeCycleAdapterQuery.java:34)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessLifeCycleAdapterOperation.doDataAccessExecute(AbstractDataAccessLifeCycleAdapterOperation.java:57)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.dataAccessExecute(AbstractDataAccessAdapterOperation.java:59)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:37)
	... 17 more
Caused by: java.lang.RuntimeException: Error while parsing date [2016-01-01]
	at com.hp.amadapter.api.TypeConverter.convertToDate(TypeConverter.java:108)
	at com.hp.amadapter.api.TypeConverter.convertFromAMType(TypeConverter.java:72)
	at com.hp.amadapter.population.query.AMTreeQuery.buildTreeNode(AMTreeQuery.java:230)
	at com.hp.amadapter.population.query.AMTreeQuery.buildResult(AMTreeQuery.java:73)
	at com.hp.amadapter.population.query.AMQueryResultSet.getNextResultChunk(AMQueryResultSet.java:26)
	at com.hp.amadapter.AMPopulationAdapter.populate(AMPopulationAdapter.java:82)

0 Likes
6 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: AMGenericAdapter - Error while parsing date [2016-01-01]

Hello ,

I hope you are doing great !

I suggest to create a support ticket to do a deep investigation.  Review the type of attributes of both applications will help because the issue will be provocated for an inconsistency between the tables .

Best Regards,

Melissa Carranza Mejias
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation. “
0 Likes
Highlighted
New Member.

Re: AMGenericAdapter - Error while parsing date [2016-01-01]

Hi Ctruong,

 

Can you please check if the date field type that uCMDB is sending to AM matches the one AM has? by default the dStart field of the contract table is Date. (there are other fields that are Date and Time)

 

Let us know how it goes.

Gerardo Mora
Software Support
hpe.com
Hewlett Packard Enterprise

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: AMGenericAdapter - Error while parsing date [2016-01-01]

This is population so it is going from AM to UCMDB.

 And it is using type Date not Date and time

 

AmContract dStart.jpg

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: AMGenericAdapter - Error while parsing date [2016-01-01]

Actually when looking at the datatype in the sql server itself dstart is shown as datetime, but when looking at it through application desginer it is Date.

 

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: AMGenericAdapter - Error while parsing date [2016-01-01]

Just created a custom attribute with datatype DATETIME and it went through fine.

So I think the problem is with how the adapter handling DATE datatype.

Any idea how to resolve this?

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: AMGenericAdapter - Error while parsing date [2016-01-01]

any advice on how to fix this? so i can populate DATE field from AM.

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.