4 Replies Latest reply on May 30, 2017 3:07 AM by Ravindrakumar Rodge

    SQL fail when I change base from custom form

    Aaron Garcia

      Hi;

       

      When I change a base form custom form SQL shows me the fail:

       

       

      I need change to base the SHR:LandingConsole. Can you help me please?

       

      Thanks

      Best regards

      Aarón

        • 1. Re: SQL fail when I change base from custom form
          Ravindrakumar Rodge

          You will need to collect API,SQL,FLTR logs in order to figure out why this error is occurring when you are trying to create custom out of base.

          Another thing is if you want to do changes to base, then what is the reason for converting it to custom when you can do the changes directly from base mode?

           

          Regards,

          Ravindrakumar

          Sr. Application Analyst

          • 2. Re: SQL fail when I change base from custom form
            Aaron Garcia

            Hi;

             

            Thanks for your update.

             

            I need to custom, because I need news views with news fields and workflow; but when I did flush cache the system lose references to SHR:LandinConsole, the solution is convert to base this form and import the Active links, but I cannot change to base.

             

            Best regards

            Aarón

            • 3. Re: SQL fail when I change base from custom form
              Aaron Garcia

              API log:

               

              <API > <TID: 0000000434> <RPC ID: 0000152821> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.3910 */ Api Trace Log -- ON (AR Server 9.1.02 201611252320)

              <API > <TID: 0000000434> <RPC ID: 0000152821> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.4540 */ -SSI              OK

              <API > <TID: 0000000434> <RPC ID: 0000152821> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.4700 */ -SE               OK

              <API > <TID: 0000000434> <RPC ID: 0000152821> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.4700 */ +GE      ARGetEntry --  from Remedy User (protocol 17) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000434> <RPC ID: 0000152821> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.4700 */ +GSI     ARGetServerInfo -- as user agarcia from Remedy User (protocol 17) at IP address 10.0.0.5 using INTERNAL // :q:0.0s

              <API > <TID: 0000000372> <RPC ID: 0000152822> <Queue: List      > <Client-RPC: 390620   > <USER: Remedy Application Service                   > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.6890 */ +GLEWF   ARGetListEntryWithFields -- schema AR System Configuration Component Setting from Unidentified Client (protocol 23) at IP address 10.0.0.5 using RPC // :q:0.15s

              <API > <TID: 0000000372> <RPC ID: 0000152822> <Queue: List      > <Client-RPC: 390620   > <USER: Remedy Application Service                   > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.7050 */ -GLEWF            OK

              <API > <TID: 0000000434> <RPC ID: 0000152821> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.7050 */ -GSI              OK

              <API > <TID: 0000000434> <RPC ID: 0000152821> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.7210 */ -GE               OK

              <API > <TID: 0000000434> <RPC ID: 0000152821> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.7210 */ -SGE              OK

              <API > <TID: 0000000334> <RPC ID: 0000152823> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.7210 */ +GS      ARGetSchema -- schema AR System Administration: Server Information from Remedy User (protocol 17) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000334> <RPC ID: 0000152823> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.7210 */ -GS               OK

              <API > <TID: 0000000369> <RPC ID: 0000152824> <Queue: List      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.7360 */ +GLEWF   ARGetListEntryWithFields -- schema AR System Administration: Client Type Configuration Setting from Remedy User (protocol 17) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000369> <RPC ID: 0000152824> <Queue: List      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:46.7360 */ -GLEWF            OK

              <API > <TID: 0000000360> <RPC ID: 0000152825> <Queue: List      > <Client-RPC: 390620   > <USER: Remedy Application Service                   > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:47.1480 */ +GLEWF   ARGetListEntryWithFields -- schema AR System Configuration Component Setting from Unidentified Client (protocol 23) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000363> <RPC ID: 0000152826> <Queue: List      > <Client-RPC: 390620   > <USER: Remedy Application Service                   > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:47.1480 */ +GLEWF   ARGetListEntryWithFields -- schema AR System Configuration Component Setting from Unidentified Client (protocol 23) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000360> <RPC ID: 0000152825> <Queue: List      > <Client-RPC: 390620   > <USER: Remedy Application Service                   > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:47.1520 */ -GLEWF            OK

              <API > <TID: 0000000363> <RPC ID: 0000152826> <Queue: List      > <Client-RPC: 390620   > <USER: Remedy Application Service                   > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:47.1520 */ -GLEWF            OK

              <API > <TID: 0000000370> <RPC ID: 0000152827> <Queue: List      > <Client-RPC: 390620   > <USER: Remedy Application Service                   > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:47.6830 */ +GLEWF   ARGetListEntryWithFields -- schema AR System Configuration Component Setting from Unidentified Client (protocol 23) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000370> <RPC ID: 0000152827> <Queue: List      > <Client-RPC: 390620   > <USER: Remedy Application Service                   > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:47.6990 */ -GLEWF            OK

              <API > <TID: 0000000327> <RPC ID: 0000152828> <Queue: Admin     > <Client-RPC: 390600   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:53.0600 */ +GSI     ARGetServerInfo -- as user agarcia from Developer Studio (protocol 23) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000327> <RPC ID: 0000152828> <Queue: Admin     > <Client-RPC: 390600   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:53.0600 */ -GSI              OK

              <API > <TID: 0000000327> <RPC ID: 0000152829> <Queue: Admin     > <Client-RPC: 390600   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:53.0600 */ +GSI     ARGetServerInfo -- as user agarcia from Developer Studio (protocol 23) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000327> <RPC ID: 0000152829> <Queue: Admin     > <Client-RPC: 390600   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:53.0600 */ -GSI              OK

              <API > <TID: 0000000327> <RPC ID: 0000152830> <Queue: Admin     > <Client-RPC: 390600   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:53.0600 */ +GLS     ARGetListSchema -- changed since Thu Jan 01 01:00:00 CET 1970 from Developer Studio (protocol 23) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000327> <RPC ID: 0000152830> <Queue: Admin     > <Client-RPC: 390600   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:53.0600 */ -GLS              OK

              <API > <TID: 0000000327> <RPC ID: 0000152831> <Queue: Admin     > <Client-RPC: 390600   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:53.9350 */ +convertOverlayconvertOverlay --  from Developer Studio (protocol 23) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000327> <RPC ID: 0000152831> <Queue: Admin     > <Client-RPC: 390600   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:41:57.6410 */ -convertOverlay       FAIL

              com.bmc.arsys.domain.etc.ARException: ERROR (552): The SQL database operation failed.; org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException

              Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__field_di__EFE1E527BD1D810F'. Cannot insert duplicate key in object 'dbo.field_dispprop'. The duplicate key value is (1268, 80161, 0, 399992384, 0).

              Error Code: 2627

              Call: INSERT INTO field_dispprop (vuiId, listIndex, schemaId, overlayGroup, fieldId, label, propLong, propShort, recordId, srvPropLong, srvPropShort) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

                bind => [11 parameters bound]

              Query: InsertObjectQuery(com.bmc.arsys.server.persistence.FieldDisppropEntity@4ac50228); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException

              Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__field_di__EFE1E527BD1D810F'. Cannot insert duplicate key in object 'dbo.field_dispprop'. The duplicate key value is (1268, 80161, 0, 399992384, 0).

              Error Code: 2627

              Call: INSERT INTO field_dispprop (vuiId, listIndex, schemaId, overlayGroup, fieldId, label, propLong, propShort, recordId, srvPropLong, srvPropShort) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

                bind => [11 parameters bound]

              Query: InsertObjectQuery(com.bmc.arsys.server.persistence.FieldDisppropEntity@4ac50228)

                at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:415) ~[bundlefile:na]

                at org.springframework.orm.jpa.aspectj.JpaExceptionTranslatorAspect.ajc$afterThrowing$org_springframework_orm_jpa_aspectj_JpaExceptionTranslatorAspect$1$18a1ac9(JpaExceptionTranslatorAspect.aj:37) ~[bundlefile:na]

                at com.bmc.arsys.server.persistence.dao.metadata.impl.MetadataDAOImpl.create(MetadataDAOImpl.java:78) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.persistence.dao.metadata.manager.impl.MetadataDAOManagerImpl.create(MetadataDAOManagerImpl.java:49) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.domain.repository.impl.MetadataRepositoryImpl.create(MetadataRepositoryImpl.java:862) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.domain.repository.impl.FormRepositoryImpl.performOperation(FormRepositoryImpl.java:3428) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.domain.repository.impl.FormRepositoryImpl.createMetadataOnly(FormRepositoryImpl.java:1079) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.domain.service.impl.OverlayServiceImpl.convertTo(OverlayServiceImpl.java:1301) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.domain.service.impl.OverlayServiceImpl.convertToBase(OverlayServiceImpl.java:1496) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl.convertOverlay_aroundBody10(OverlayFacadeImpl.java:121) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl$AjcClosure11.run(OverlayFacadeImpl.java:1) ~[bundlefile:9.1.02-SNAPSHOT]

                at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:66) ~[bundlefile:na]

                at org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:72) ~[bundlefile:na]

                at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) ~[bundlefile:na]

                at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:70) ~[bundlefile:na]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl.convertOverlay_aroundBody12(OverlayFacadeImpl.java:86) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl$AjcClosure13.run(OverlayFacadeImpl.java:1) ~[bundlefile:9.1.02-SNAPSHOT]

                at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [bundlefile:1.8.4]

                at com.bmc.arsys.server.internal.aspects.ARTransactionalManager.manageGeneralTransaction(ARTransactionalManager.java:227) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.internal.aspects.ARTransactionalManager.manageTransaction(ARTransactionalManager.java:152) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl.convertOverlay_aroundBody14(OverlayFacadeImpl.java:86) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl$AjcClosure15.run(OverlayFacadeImpl.java:1) ~[bundlefile:9.1.02-SNAPSHOT]

                at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:221) [bundlefile:1.8.4]

                at com.bmc.arsys.server.internal.aspects.PostTransactionalOpsHandler.monitor(PostTransactionalOpsHandler.java:47) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl.convertOverlay_aroundBody16(OverlayFacadeImpl.java:86) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl$AjcClosure17.run(OverlayFacadeImpl.java:1) ~[bundlefile:9.1.02-SNAPSHOT]

                at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:221) [bundlefile:1.8.4]

                at com.bmc.arsys.server.internal.aspects.AccessControlInterceptor.monitorFacadeMethod(AccessControlInterceptor.java:209) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl.convertOverlay_aroundBody18(OverlayFacadeImpl.java:86) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl$AjcClosure19.run(OverlayFacadeImpl.java:1) ~[bundlefile:9.1.02-SNAPSHOT]

                at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [bundlefile:1.8.4]

                at com.bmc.arsys.server.internal.aspects.ApiTracer.monitor(ApiTracer.java:188) ~[bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.facade.impl.OverlayFacadeImpl.convertOverlay(OverlayFacadeImpl.java:86) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.extension.internalApi.impl.ApiBaseImpl.convertOverlay_aroundBody422(ApiBaseImpl.java:1985) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.extension.internalApi.impl.ApiBaseImpl$AjcClosure423.run(ApiBaseImpl.java:1) [bundlefile:9.1.02-SNAPSHOT]

                at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [bundlefile:1.8.4]

                at com.bmc.arsys.server.internal.aspects.ApiEventAspect.apiMethod(ApiEventAspect.java:44) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.server.extension.internalApi.impl.ApiBaseImpl.convertOverlay(ApiBaseImpl.java:1984) [bundlefile:9.1.02-SNAPSHOT]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_131]

                at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_131]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_131]

                at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_131]

                at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [bundlefile:na]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [bundlefile:na]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [bundlefile:na]

                at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) [bundlefile:2.0.0]

                at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) [bundlefile:2.0.0]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [bundlefile:na]

                at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) [bundlefile:na]

                at com.sun.proxy.$Proxy89.convertOverlay(Unknown Source) [na:na]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_131]

                at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_131]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_131]

                at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_131]

                at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [bundlefile:na]

                at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) [bundlefile:2.0.0]

                at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) [bundlefile:2.0.0]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [bundlefile:na]

                at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) [bundlefile:na]

                at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) [bundlefile:na]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [bundlefile:na]

                at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) [bundlefile:2.0.0]

                at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) [bundlefile:2.0.0]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [bundlefile:na]

                at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) [bundlefile:2.0.0]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [bundlefile:na]

                at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) [bundlefile:na]

                at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) [bundlefile:na]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [bundlefile:na]

                at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) [bundlefile:na]

                at com.sun.proxy.$Proxy17.convertOverlay(Unknown Source) [na:na]

                at com.bmc.arsys.serverrpc.RpcCallProcessor.ArCreateOverlayFromObject_23(RpcCallProcessor.java:5499) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.arrpc.version23.ARServerDispatcher_23.handleCall(ARServerDispatcher_23.java:1728) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.arrpc.ARServerDispatcher.dispatchOncRpcCall(ARServerDispatcher.java:170) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatch(ArRpcCallHandler.java:826) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.serverrpc.nio.RPCCallHandler.dispatch(RPCCallHandler.java:668) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(ArRpcCallHandler.java:814) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.callDispatcher(ArRpcCallHandler.java:478) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(ArRpcCallHandler.java:290) [bundlefile:9.1.02-SNAPSHOT]

                at com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(ArRpcCallHandler.java:567) [bundlefile:9.1.02-SNAPSHOT]

                at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_131]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_131]

                at java.lang.Thread.run(Unknown Source) [na:1.8.0_131]

                at com.bmc.arsys.serverrpc.nio.ARThreadFactory$ARWorkerThread.run(ARThreadFactory.java:74) [bundlefile:9.1.02-SNAPSHOT]

              Caused by: org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException

              Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__field_di__EFE1E527BD1D810F'. Cannot insert duplicate key in object 'dbo.field_dispprop'. The duplicate key value is (1268, 80161, 0, 399992384, 0).

              Error Code: 2627

              Call: INSERT INTO field_dispprop (vuiId, listIndex, schemaId, overlayGroup, fieldId, label, propLong, propShort, recordId, srvPropLong, srvPropShort) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

                bind => [11 parameters bound]

              Query: InsertObjectQuery(com.bmc.arsys.server.persistence.FieldDisppropEntity@4ac50228); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException

              Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__field_di__EFE1E527BD1D810F'. Cannot insert duplicate key in object 'dbo.field_dispprop'. The duplicate key value is (1268, 80161, 0, 399992384, 0).

              Error Code: 2627

              Call: INSERT INTO field_dispprop (vuiId, listIndex, schemaId, overlayGroup, fieldId, label, propLong, propShort, recordId, srvPropLong, srvPropShort) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

                bind => [11 parameters bound]

              Query: InsertObjectQuery(com.bmc.arsys.server.persistence.FieldDisppropEntity@4ac50228)

                ... 84 common frames omitted

              Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException

              Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__field_di__EFE1E527BD1D810F'. Cannot insert duplicate key in object 'dbo.field_dispprop'. The duplicate key value is (1268, 80161, 0, 399992384, 0).

              Error Code: 2627

              Call: INSERT INTO field_dispprop (vuiId, listIndex, schemaId, overlayGroup, fieldId, label, propLong, propShort, recordId, srvPropLong, srvPropShort) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

                bind => [11 parameters bound]

              Query: InsertObjectQuery(com.bmc.arsys.server.persistence.FieldDisppropEntity@4ac50228)

                at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:804) ~[na:na]

                at sun.reflect.GeneratedMethodAccessor284.invoke(Unknown Source) ~[na:na]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_131]

                at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_131]

                at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:291) ~[bundlefile:na]

                at com.sun.proxy.$Proxy58.flush(Unknown Source) ~[na:na]

                ... 82 common frames omitted

              Caused by: org.eclipse.persistence.exceptions.DatabaseException:

              Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__field_di__EFE1E527BD1D810F'. Cannot insert duplicate key in object 'dbo.field_dispprop'. The duplicate key value is (1268, 80161, 0, 399992384, 0).

              Error Code: 2627

              Call: INSERT INTO field_dispprop (vuiId, listIndex, schemaId, overlayGroup, fieldId, label, propLong, propShort, recordId, srvPropLong, srvPropShort) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

                bind => [11 parameters bound]

              Query: InsertObjectQuery(com.bmc.arsys.server.persistence.FieldDisppropEntity@4ac50228)

                at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) ~[bundlefile:na]

                at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:851) ~[bundlefile:na]

                at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:913) ~[bundlefile:na]

                at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:594) ~[bundlefile:na]

                at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:537) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1805) ~[bundlefile:na]

                at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:286) ~[na:na]

                at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) ~[na:na]

                at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) ~[na:na]

                at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342) ~[na:na]

                at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162) ~[na:na]

                at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177) ~[na:na]

                at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:471) ~[na:na]

                at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) ~[bundlefile:na]

                at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) ~[bundlefile:na]

                at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:286) ~[na:na]

                at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) ~[bundlefile:na]

                at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:852) ~[bundlefile:na]

                at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:751) ~[bundlefile:na]

                at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) ~[bundlefile:na]

                at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2879) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1607) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1589) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1540) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:226) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:193) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:138) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3945) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1423) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:638) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1569) ~[bundlefile:na]

                at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:445) ~[bundlefile:na]

                at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:798) ~[na:na]

                ... 87 common frames omitted

              Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__field_di__EFE1E527BD1D810F'. Cannot insert duplicate key in object 'dbo.field_dispprop'. The duplicate key value is (1268, 80161, 0, 399992384, 0).

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc-4.0.jar:na]

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc-4.0.jar:na]

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc-4.0.jar:na]

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc-4.0.jar:na]

                at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc-4.0.jar:na]

                at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc-4.0.jar:na]

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc-4.0.jar:na]

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc-4.0.jar:na]

                at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc-4.0.jar:na]

                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]

                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]

                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]

                at net.sf.log4jdbc.PreparedStatementSpy.executeUpdate(PreparedStatementSpy.java:1022) ~[log4jdbc-remix-0.2.7.jar:na]

                at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:842) ~[bundlefile:na]

                ... 119 common frames omitted

              <API > <TID: 0000000371> <RPC ID: 0000152832> <Queue: List      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:42:04.9460 */ +GLEWF   ARGetListEntryWithFields -- schema AR System Administration: Client Type Configuration Setting from Remedy User (protocol 17) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000371> <RPC ID: 0000152832> <Queue: List      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:42:04.9460 */ -GLEWF            OK

              <API > <TID: 0000000330> <RPC ID: 0000152833> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:42:04.9460 */ +SGE     ARSetGetEntry -- schema AR System Administration: Server Information entryId 000000000000001 from Remedy User (protocol 17) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000330> <RPC ID: 0000152833> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:42:04.9460 */ +SE      ARSetEntry -- schema AR System Administration: Server Information entryId 000000000000001 from Remedy User (protocol 17) at IP address 10.0.0.5 using RPC // :q:0.0s

              <API > <TID: 0000000330> <RPC ID: 0000152833> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:42:04.9620 */ +SSI     ARSetServerInfo -- as user agarcia from Remedy User (protocol 17) at IP address 10.0.0.5 using INTERNAL // :q:0.0s

              <API > <TID: 0000000330> <RPC ID: 0000152833> <Queue: Fast      > <Client-RPC: 390620   > <USER: agarcia                                      > <Overlay-Group: 1         > /* Tue May 30 2017 09:42:05.0090 */ Api Trace Log -- OFF (AR Server 9.1.02 201611252320)

              • 4. Re: SQL fail when I change base from custom form
                Ravindrakumar Rodge

                The error indicate that you have a primary key defined on dbo.field_dispprop table and that is not allowing to perform insert on the dbo.field_dispprop.

                 

                Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__field_di__EFE1E527BD1D810F'. Cannot insert duplicate key in object 'dbo.field_dispprop'. The duplicate key value is (1268, 80161, 0, 399992384, 0).

                Error Code: 2627

                Call: INSERT INTO field_dispprop (vuiId, listIndex, schemaId, overlayGroup, fieldId, label, propLong, propShort, recordId, srvPropLong, srvPropShort) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

                 

                Primary Key: PK_field_di_EFE1E527BD1D810F

                 

                Take help of DBA and get rid of the key and then try.

                 

                Regards,

                Ravindrakumar

                Sr. Application Analyst

                1 of 1 people found this helpful