FAC DOES NOT WORKING

[Marcos Cardoso]

Hello everyone,

I'm having an issue with FAC that I have applied on my customer. That customer has a big pool of analog phones and when he decided to apply FAC for all phones we got a big surprise. All Nacional and local calls are working properly, but just call to mobiles do not working. I have enabled debugs on gateway but I haven't get these calls. After enabled the SDL debug on Callmanager, I got the message displayed bellow:

with parameters callingPartyNumberPi=0, fqdn=, cgpn=5531XXXX8604, pPrecedenceLevelcssId=6, sipPatternUsage=2, sipTransformedDialedDigits=0XXXX0683,1, deviceTimeZone=22, Year=2013, Month=6, DayOfWeek=3,Day=2, Hour=22, Minute=24, Second=55, Millisecond=983, milliSecAfterConversion=1372803895

2013-07-02 23:03:59,893 INFO  [http-8443-9] dnaServer.DoAnalysis - doanalysisWithCgpnAndCss : The result after match is |PretransformCallingPartyNumber=5531XXXX8604|CallingPartyNumber=5531XXXX8604|DialingPartition=PT-PSTN-FAC|DialingPattern=0.[6-9]XXXXXXX?|FullyQualifiedCalledPartyNumber=0XXXX0683|DialingPatternRegularExpression=(0)([6-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]?)|DialingWhere=|PatternType=Enterprise|PotentialMatches=ExclusivelyOffNetPotentialMatchesExist|DialingSdlProcessId=(1,36625,1)|PretransformDigitString=0XXXX0683|PretransformTagsList=ACCESS-CODE:SUBSCRIBER|PretransformPositionalMatchList=0:XXXX0683|CollectedDigits=0XXXX0683|UnconsumedDigits=|TagsList=ACCESS-CODE:SUBSCRIBER|PositionalMatchList=0:XXXX0683|VoiceMailbox=|VoiceMailCallingSearchSpace=|VoiceMailPilotNumber=|RouteBlockFlag=RouteThisPattern|RouteBlockCause=0|AlertingName=|UnicodeDisplayName=䤀|DisplayNameLocale=1|OverlapSendingFlagEnabled=0|WithTags=|WithValues=|CallingPartyNumberPi=NotSelected|ConnectedPartyNumberPi=NotSelected|CallingPartyNamePi=NotSelected|ConnectedPartyNamePi=NotSelected|CallManagerDeviceType=AccessDevice|PatternPrecedenceLevel=PlDefault|CallableEndPointName=[e66ea29b-3b88-eabe-e69b-b825d46a817e]|PatternNodeId=[69335123-8424-4e1b-b018-e52bf53056ce]|AARNeighborhood=[]|AARDestinationMask=[]|AARKeepCallHistory=true|AARVoiceMailEnabled=false|NetworkLocation=OffNet|Calling Party Number Type=Cisco Unified CallManager|Calling Party Numbering Plan=Cisco Unified CallManager|Called Party Number Type=Cisco Unified CallManager|Called Party Numbering Plan=Cisco Unified CallManager|ProvideOutsideDialtone=true|AllowDeviceOverride=false|AlternateMatches=|TranslationPatternDetails=|ResourcePriorityNamespace=|PatternRouteClass=RouteClassDefault

2013-07-02 23:03:59,893 INFO  [http-8443-9] dnaServer.XMLOutput - formatXMLOutput: Started - Formatting of XML output

2013-07-02 23:03:59,893 INFO  [http-8443-9] dnaServer.XMLOutput - parseDaResults: Started - Parsing of DaResult

2013-07-02 23:03:59,894 INFO  [http-8443-9] dnaServer.XMLOutput - parseDaResults: Completed - Parsing of DaResult

2013-07-02 23:03:59,910 INFO  [http-8443-9] dnaServer.XMLOutput - getCallingAndCalledTransformations: Obtained Trunk calling and called party transformations

2013-07-02 23:03:59,911 INFO  [http-8443-9] dnaServer.TranslationOutput - getTranslationPatternTags: Obtained Translation Pattern Details: CallingPtyNum = 5531XXXX8604, Pattern = , PreTransformCallingPtyNum = , PreTransformDigitString = , CollectedDigits =

2013-07-02 23:03:59,923 INFO  [http-8443-9] dnaServer.XMLOutput - getCallingAndCalledTransformations: Obtained Trunk calling and called party transformations

2013-07-02 23:03:59,948 INFO  [http-8443-9] dnaServer.TrunkOutput - PreTransformCallingPartyNumber obtained from the translation details:

2013-07-02 23:04:00,087 INFO  [http-8443-9] dnaServer.XMLOutput - Get Device Data

2013-07-02 23:04:00,096 INFO  [http-8443-9] dnaServer.XMLOutput - getDeviceStatus: Obtained device status info - UnKnown

2013-07-02 23:04:00,101 INFO  [http-8443-9] dnaServer.GatewayBase - getH323GatewayDetails: Getting H323 Gateway Details

2013-07-02 23:04:00,106 INFO  [http-8443-9] dnaServer.GatewayBase - getH323GatewayDetails: Obtained H323 Gateway Details

2013-07-02 23:04:00,150 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: Error running query - select name,usedevicepoolcgpntransformcss from device where pkid = (select fkdevice from devicenumplanmap where fknumplan = ( select  pkid from numplan where dnorpattern = "0.[6-9]XXXXXXX?"))

2013-07-02 23:04:00,150 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: DESC=A subquery has returned not exactly one row., Error Code=java.sql.SQLException: A subquery has returned not exactly one row.

2013-07-02 23:04:00,156 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: Error running query - select name,usedevicepoolcdpntransformcss from device where pkid = (select fkdevice from devicenumplanmap where fknumplan = ( select  pkid from numplan where dnorpattern = "0.[6-9]XXXXXXX?"))

2013-07-02 23:04:00,156 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: DESC=A subquery has returned not exactly one row., Error Code=java.sql.SQLException: A subquery has returned not exactly one row.

2013-07-02 23:04:00,159 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: Error running query - select fkcallingsearchspace_cdpntransform from device where pkid = (select fkdevice from devicenumplanmap where fknumplan = ( select  pkid from numplan where dnorpattern = '0.[6-9]XXXXXXX?'))

2013-07-02 23:04:00,160 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: DESC=A subquery has returned not exactly one row., Error Code=java.sql.SQLException: A subquery has returned not exactly one row.

2013-07-02 23:04:00,940 INFO  [http-8443-9] dnaServer.XMLOutput - resultsSummaryDetails: Obtained Results Summary details

2013-07-02 23:04:00,941 INFO  [http-8443-9] dnaServer.XMLOutput - AlternateMatches is NULL

2013-07-02 23:04:00,941 INFO  [http-8443-9] dnaServer.XMLOutput - formatXMLOutput: Completed - Formatting of XML output

2013-07-02 23:04:00,941 INFO  [http-8443-9] dnaServer.DoAnalysis - doanalysisWithCgpnAndCss: Analysis Complete

2013-07-02 23:17:45,416 INFO  [http-8443-9] dnaServer.DNAMainServlet - Processing Request for the parameters: outputKey=1&cgpn=5531XXXX8604&dialedDigits=084919083&cssId=960b03d0-d461-0aa0-fa2b-2d7555e1fc35&deviceTimeZone=22&timeZone=22&day=2&month=6&year=2013&hour=22&min=24&sec=55&milliSec=983&sipAnalysis=0

2013-07-02 23:17:45,444 INFO  [http-8443-9] dnaServer.DoAnalysis - doanalysisWithCgpnAndCss: TimeZoneIndex is 22

2013-07-02 23:17:45,444 INFO  [http-8443-9] dnaServer.DoAnalysis - doanalysisWithCgpnAndCss: TimeZoneValue is Etc/GMT

2013-07-02 23:17:45,444 INFO  [http-8443-9] dnaServer.DoAnalysis - Time/Date in DD/MM/YY HH:MM:SS format is - 5/2/1 11:12:13

2013-07-02 23:17:45,445 INFO  [http-8443-9] dnaServer.DoAnalysis - Converted value of Time/Date to GMT in DD/MM/YY HH:MM:SS format is - 2/6/2013 22:24:55

2013-07-02 23:17:45,445 INFO  [http-8443-9] dnaServer.DoAnalysis - doanalysisWithCgpnAndCss: Analyzing with parameters - cgpn=55312138604, cssId=960b03d0-d461-0aa0-fa2b-2d7555e1fc35,dialedDigits=0XXXX9083

2013-07-02 23:17:45,447 INFO  [http-8443-9] dnaServer.DoAnalysis - SipTransformedDialedDigits is 0XXXX9083

2013-07-02 23:17:45,450 INFO  [http-8443-9] dnaServer.DoAnalysis - doanalysisWithCgpnAndCss : Calling match with parameters callingPartyNumberPi=0, fqdn=, cgpn=55312138604, pPrecedenceLevelcssId=6, sipPatternUsage=2, sipTransformedDialedDigits=0XXXX9083,1, deviceTimeZone=22, Year=2013, Month=6, DayOfWeek=3,Day=2, Hour=22, Minute=24, Second=55, Millisecond=983, milliSecAfterConversion=1372803895

2013-07-02 23:17:45,493 INFO  [http-8443-9] dnaServer.DoAnalysis - doanalysisWithCgpnAndCss : The result after match is |PretransformCallingPartyNumber=55312138604|CallingPartyNumber=55312138604|DialingPartition=PT-PSTN-FAC|DialingPattern=0.[6-9]XXXXXXX?|FullyQualifiedCalledPartyNumber=084919083|DialingPatternRegularExpression=(0)([6-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]?)|DialingWhere=|PatternType=Enterprise|PotentialMatches=ExclusivelyOffNetPotentialMatchesExist|DialingSdlProcessId=(1,36625,1)|PretransformDigitString=0XXXX9083|PretransformTagsList=ACCESS-CODE:SUBSCRIBER|PretransformPositionalMatchList=0:84919083|CollectedDigits=084919083|UnconsumedDigits=|TagsList=ACCESS-CODE:SUBSCRIBER|PositionalMatchList=0:XXXX9083|VoiceMailbox=|VoiceMailCallingSearchSpace=|VoiceMailPilotNumber=|RouteBlockFlag=RouteThisPattern|RouteBlockCause=0|AlertingName=|UnicodeDisplayName=䤀|DisplayNameLocale=1|OverlapSendingFlagEnabled=0|WithTags=|WithValues=|CallingPartyNumberPi=NotSelected|ConnectedPartyNumberPi=NotSelected|CallingPartyNamePi=NotSelected|ConnectedPartyNamePi=NotSelected|CallManagerDeviceType=AccessDevice|PatternPrecedenceLevel=PlDefault|CallableEndPointName=[e66ea29b-3b88-eabe-e69b-b825d46a817e]|PatternNodeId=[69335123-8424-4e1b-b018-e52bf53056ce]|AARNeighborhood=[]|AARDestinationMask=[]|AARKeepCallHistory=true|AARVoiceMailEnabled=false|NetworkLocation=OffNet|Calling Party Number Type=Cisco Unified CallManager|Calling Party Numbering Plan=Cisco Unified CallManager|Called Party Number Type=Cisco Unified CallManager|Called Party Numbering Plan=Cisco Unified CallManager|ProvideOutsideDialtone=true|AllowDeviceOverride=false|AlternateMatches=|TranslationPatternDetails=|ResourcePriorityNamespace=|PatternRouteClass=RouteClassDefault

2013-07-02 23:17:45,494 INFO  [http-8443-9] dnaServer.XMLOutput - formatXMLOutput: Started - Formatting of XML output

2013-07-02 23:17:45,494 INFO  [http-8443-9] dnaServer.XMLOutput - parseDaResults: Started - Parsing of DaResult

2013-07-02 23:17:45,495 INFO  [http-8443-9] dnaServer.XMLOutput - parseDaResults: Completed - Parsing of DaResult

2013-07-02 23:17:45,509 INFO  [http-8443-9] dnaServer.XMLOutput - getCallingAndCalledTransformations: Obtained Trunk calling and called party transformations

2013-07-02 23:17:45,510 INFO  [http-8443-9] dnaServer.TranslationOutput - getTranslationPatternTags: Obtained Translation Pattern Details: CallingPtyNum = 55312138604, Pattern = , PreTransformCallingPtyNum = , PreTransformDigitString = , CollectedDigits =

2013-07-02 23:17:45,520 INFO  [http-8443-9] dnaServer.XMLOutput - getCallingAndCalledTransformations: Obtained Trunk calling and called party transformations

2013-07-02 23:17:45,542 INFO  [http-8443-9] dnaServer.TrunkOutput - PreTransformCallingPartyNumber obtained from the translation details:

2013-07-02 23:17:45,719 INFO  [http-8443-9] dnaServer.XMLOutput - Get Device Data

2013-07-02 23:17:45,726 INFO  [http-8443-9] dnaServer.XMLOutput - getDeviceStatus: Obtained device status info - UnKnown

2013-07-02 23:17:45,731 INFO  [http-8443-9] dnaServer.GatewayBase - getH323GatewayDetails: Getting H323 Gateway Details

2013-07-02 23:17:45,735 INFO  [http-8443-9] dnaServer.GatewayBase - getH323GatewayDetails: Obtained H323 Gateway Details

2013-07-02 23:17:45,744 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: Error running query - select name,usedevicepoolcgpntransformcss from device where pkid = (select fkdevice from devicenumplanmap where fknumplan = ( select  pkid from numplan where dnorpattern = "0.[6-9]XXXXXXX?"))

2013-07-02 23:17:45,745 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: DESC=A subquery has returned not exactly one row., Error Code=java.sql.SQLException: A subquery has returned not exactly one row.

2013-07-02 23:17:45,750 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: Error running query - select name,usedevicepoolcdpntransformcss from device where pkid = (select fkdevice from devicenumplanmap where fknumplan = ( select  pkid from numplan where dnorpattern = "0.[6-9]XXXXXXX?"))

2013-07-02 23:17:45,751 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: DESC=A subquery has returned not exactly one row., Error Code=java.sql.SQLException: A subquery has returned not exactly one row.

2013-07-02 23:17:45,754 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: Error running query - select fkcallingsearchspace_cdpntransform from device where pkid = (select fkdevice from devicenumplanmap where fknumplan = ( select  pkid from numplan where dnorpattern = '0.[6-9]XXXXXXX?'))

2013-07-02 23:17:45,754 ERROR [http-8443-9] dnaServer.XMLOutput - doanalysisWithCgpnAndCss: DESC=A subquery has returned not exactly one row., Error Code=java.sql.SQLException: A subquery has returned not exactly one row.

2013-07-02 23:17:46,492 INFO  [http-8443-9] dnaServer.XMLOutput - resultsSummaryDetails: Obtained Results Summary details

2013-07-02 23:17:46,493 INFO  [http-8443-9] dnaServer.XMLOutput - AlternateMatches is NULL

2013-07-02 23:17:46,493 INFO  [http-8443-9] dnaServer.XMLOutput - formatXMLOutput: Completed - Formatting of XML output

2013-07-02 23:17:46,494 INFO  [http-8443-9] dnaServer.DoAnalysis - doanalysisWithCgpnAndCss: Analysis Complete

I replaced DDI number to XXXX for security reasons.

Please could anyone give a north into this issue! I'm going apreciate any help!

Thanks a lot

Marcos Cardoso

[Bruno Rangel]

Hi Marcos

What do you mean with Calls to mobile not working? That calls aren´t going through ? Check if your Route-pattern is configured properly, have you performed a test with DNA?

Give us more details regarding your problem also give us the calling and called number.

Cheers
Bruno Rangel

"Se você quiser alguém em quem confiar, confie em si mesmo. Quem acredita sempre alcança"
Renato Russo

[Aman Soi]

Hi,

In addition to what Mr. Bruno has siad, can u try removing FAC and then, try calling mobile number?

regds,

aman

[Marcos Cardoso]

Hi Bruno,

For IP Phones ALL calls working fine with FAC, but when I tried to do the same with analog phones just calls to mobile phones did not work. When I put out fac for all phones the customer is able to make any call include mobile calls from analog phones.

In addition, I set up two router patterns with and without FAC.