Unsolved
This post is more than 5 years old
5 Posts
0
427
July 14th, 2008 14:00
ETL error in ECCv6 StorageScope
Hi,
I am getting the following ETL error in the srmetl_run_status.log. All other SP seems to be ok, except this one!
Any help would be appreciated.
populate_srmhostdevice Mon Jul 14 15:46:14 CDT 2008 Mon Jul 14 15:46:21 CDT 2008 7 ERROR 0 ERROR Running in ConnID [targetDb] - [INSERT /*+ APPEND PARALLEL(srmhostdevice, 2) */ INTO srmhostdevice(ARRAYDEVICEKEY, HDNAME, HDPRODUCT, HDREVISION, HDTOTAL, HDTYPE, HDVENDOR, HOSTDEVICEID, HOSTDEVICEKEY, HOSTKEY, LASTDISCOVERYTIME, RESIDESON, ARRAYKEY, HDBLOCKSIZE, HDNUMBEROFCYLINDERS, HDPOWERPATHDEVID, HDPOWERPATHDEVNAME, HDSECTORSPERTRACK, HDSTATE, HDTRACKSPERCYLINDER, USEDBYFILESYSTEM, USEDBYVOLUMEGROUP, ISPSEUDO, IsPowerpathParent) SELECT /*+ APPEND PARALLEL(stssys.STS_HOST_DEVICE@rambdb, 2) */ SD_ID, HD_NAME, HD_PRODUCT, HD_REVISION, HD_TOTAL, HD_TYPE, HD_VENDOR, HD_ID, HD_ID, HOST_ID, null, ARRAYJBOD_TYPE, ST_ID, HD_BLOCKSIZE, HD_NUMCYLINDERS, HD_PPDEV_ID, HD_PPDEV, HD_SECTORSTRACK, HD_STATE, HD_TRACKSCYLINDER, USED_BY_FS, USED_BY_VG, IS_PSEUDO, is_powerpath_parent FROM stssys.STS_HOST_DEVICE@rambdb]: In Database Class:runDMLQuery:catch SQLException: Query Execution Failed: ORA-00001: unique constraint (EMCSTS.PK_SRMHOSTDEVICE) violated
What is this ORA-00001 error?
Thanks
I am getting the following ETL error in the srmetl_run_status.log. All other SP seems to be ok, except this one!
Any help would be appreciated.
populate_srmhostdevice Mon Jul 14 15:46:14 CDT 2008 Mon Jul 14 15:46:21 CDT 2008 7 ERROR 0 ERROR Running in ConnID [targetDb] - [INSERT /*+ APPEND PARALLEL(srmhostdevice, 2) */ INTO srmhostdevice(ARRAYDEVICEKEY, HDNAME, HDPRODUCT, HDREVISION, HDTOTAL, HDTYPE, HDVENDOR, HOSTDEVICEID, HOSTDEVICEKEY, HOSTKEY, LASTDISCOVERYTIME, RESIDESON, ARRAYKEY, HDBLOCKSIZE, HDNUMBEROFCYLINDERS, HDPOWERPATHDEVID, HDPOWERPATHDEVNAME, HDSECTORSPERTRACK, HDSTATE, HDTRACKSPERCYLINDER, USEDBYFILESYSTEM, USEDBYVOLUMEGROUP, ISPSEUDO, IsPowerpathParent) SELECT /*+ APPEND PARALLEL(stssys.STS_HOST_DEVICE@rambdb, 2) */ SD_ID, HD_NAME, HD_PRODUCT, HD_REVISION, HD_TOTAL, HD_TYPE, HD_VENDOR, HD_ID, HD_ID, HOST_ID, null, ARRAYJBOD_TYPE, ST_ID, HD_BLOCKSIZE, HD_NUMCYLINDERS, HD_PPDEV_ID, HD_PPDEV, HD_SECTORSTRACK, HD_STATE, HD_TRACKSCYLINDER, USED_BY_FS, USED_BY_VG, IS_PSEUDO, is_powerpath_parent FROM stssys.STS_HOST_DEVICE@rambdb]: In Database Class:runDMLQuery:catch SQLException: Query Execution Failed: ORA-00001: unique constraint (EMCSTS.PK_SRMHOSTDEVICE) violated
What is this ORA-00001 error?
Thanks
No Events found!
seamuscoffey
472 Posts
0
July 17th, 2008 00:00
Please apply the latest 6.0 Java infrastructure hotfix, patch 4283, which is now available to download from Powerlink. This does contain some ETL fixes and will upgrade Server/Store/Console/StorageScope to 6.0.0.0.463.
If the issue still persists then I highly recommend opening a Service Request with EMC Customer Support. We have seen some issues recently with ETL failures.
Regards,
Séamus Coffey
EMC Global Services
seamuscoffey
472 Posts
0
September 15th, 2008 00:00
Regards,
Séamus Coffey
EMC Global Services