04-21-2010 03:59 PM - edited 03-15-2019 10:24 PM
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
----
Solved! Go to Solution.
04-22-2010 12:21 AM
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...
04-22-2010 12:47 AM
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.
04-22-2010 12:21 AM
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...
04-22-2010 12:47 AM
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.
04-28-2010 01:41 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide