Solved: DMA warnings during CM upgrade from 4.3 to 7.1(2b)

bbartkiewicz · ‎04-21-2010

Hi,

During DMA process we've got some warnings as for example bellow.

Do you know if the warnings of this type has to be eliminated and DMA repeated before importing database to version 7.1(2)?

Thanks in advance

Bartek

The full list of warnings is attached additionally.

---

Row: 33 SQL error: -746(35133)
   Error executing "update CallingSearchSpace set Name='MOBILE_CSS' where pkid='08180564-28a9-46e5-8e25-a2e890192b4f'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -746. sqlerrm(35133)
      pkid                       08180564-28a9-46e5-8e25-a2e890192b4f NOT MODIFIABLE
      Name                       MOBILE_CSS
      Description                BLOCK - Poziom rozmowy komAfÂ3rkowe
      DialPlanWizardGenID
      Clause                     BLOCK_INTERNATIONAL_PT:BLOCK_COMMERCIAL_PT:BLOCK_INTERNET_PT NOT MODIFIABLE
      resetToggle                false
      tkReset                    2
      tkPartitionUsage           99 NOT MODIFIABLE

Table: CallingSearchSpaceMember 2010-04-03 17:29:23

   Row: 3 SQL error: -746(35133)
   Error executing "update CallingSearchSpaceMember set fkRoutePartition='06231d83-5daa-4ccb-9ff7-d65407f9bafb' where pkid='df4cae0d-0403-48aa-b5e6-058f62a43d86'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -746. sqlerrm(35133)
      pkid                       df4cae0d-0403-48aa-b5e6-058f62a43d86 NOT MODIFIABLE
      fkCallingSearchSpace       08180564-28a9-46e5-8e25-a2e890192b4f NOT MODIFIABLE
      fkRoutePartition           06231d83-5daa-4ccb-9ff7-d65407f9bafb
      SortOrder                  3

---

Table: DeviceNumPlanMap 2010-04-03 17:33:34

   Row: 377 SQL error: -746(35317)
   Error executing "update DeviceNumPlanMap set fkDevice='768ab1f8-905c-438c-888e-6d0b92821ace' where pkid='7ec1635d-51e5-48fb-98bf-1d612f11f0ea'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -746. sqlerrm(35317)
      pkid                       7ec1635d-51e5-48fb-98bf-1d612f11f0ea NOT MODIFIABLE
      fkDevice                   768ab1f8-905c-438c-888e-6d0b92821ace
      NumPlanIndex               1
      Label                      Pos Gab 202 zabiegowy ogAfÂ3lny
      fkNumPlan                  7c8d93be-3255-44f1-9c4c-2c8fcffbdf2f
      Display                    Pos Gab 202 zabiegowy ogAfÂ3lny
      tkRingSetting              0
      CtiID                      377 NOT MODIFIABLE
      E164Mask                   0224504502
      DialPlanWizardGenID
      tkMWLPolicy                0
      tkRingSetting_Consecutive 0
      MaxNumCalls                4
      BusyTrigger                2
      CallInfoDisplayMask        9
      LabelASCII
      DisplayASCII
      tkRingSetting_ActivePickupAlert 0
      tkRingSetting_IdlePickupAlert 0
      tkPartitionUsage           99 NOT MODIFIABLE
      SpeedDial
      fkRecordingProfile
      fkCallingSearchSpace_Monitoring
      tkStatus_AudibleMWI        2
      LogMissedCalls             true

----

Aaron Harrison · ‎04-22-2010

Hi

I would strongly suspect that the special characters in your 'description' field are causing it to error.

I would try removing your fancy A character with the jaunty hat on it, and re run. Once the upgrade is done, try putting it back if you like.

Regards

Aaron

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

View solution in original post

Ayodeji Okanlawon · ‎04-22-2010

In my experience and having done a few DMA backups/import, I have observed that as long as you have your tar file you should be good to go. You may look at the warnings and see if they are things you will like to tidy up as they could be uneccesary garbage you dont want carry over into your new fancy "CCM7.1". In terms of if your upgrade will succeed or not, that doesnt affect it.

Please rate all useful posts

View solution in original post

Aaron Harrison · ‎04-22-2010

Hi

I would strongly suspect that the special characters in your 'description' field are causing it to error.

I would try removing your fancy A character with the jaunty hat on it, and re run. Once the upgrade is done, try putting it back if you like.

Regards

Aaron

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

Ayodeji Okanlawon · ‎04-22-2010

In my experience and having done a few DMA backups/import, I have observed that as long as you have your tar file you should be good to go. You may look at the warnings and see if they are things you will like to tidy up as they could be uneccesary garbage you dont want carry over into your new fancy "CCM7.1". In terms of if your upgrade will succeed or not, that doesnt affect it.

Please rate all useful posts

bbartkiewicz · ‎04-28-2010

Hi,

Thank you very much for the answers.

Yesterday we imported DMA database (with warnings) to new CM 7.1(2b) without any problems.

Your advices have been very precious and correct.

I'm not sure how to add points for your help because I'm dooing this for the firs time. I've just pressed "correct answer" button and I hope it is ok. In case the points have not been added send me a mail.

Best regards

Bartek