Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

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

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

----

Everyone's tags (2)
2 ACCEPTED SOLUTIONS

Accepted Solutions
Super Bronze

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

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!
VIP Super Bronze

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

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 "The essence of christianity is not the enthronement but the obliteration of self --William Barclay"
3 REPLIES
Super Bronze

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

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!
VIP Super Bronze

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

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 "The essence of christianity is not the enthronement but the obliteration of self --William Barclay"
New Member

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

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

463
Views
10
Helpful
3
Replies
CreatePlease to create content