Problems with Unity Outbound fax

[Florian Zahn]

Hi,

here we are setting up a pilot installation of Cisco Unity. I also installed the T.37 Store and forward fax functionality with a 2611XM gateway-router.

Everythink worked fine for some days. But since today I cannot process outgoing faxes and I get the following failure in my IPFaxSvc logfile:

"2005-08-15","17:01:01","Processing outbox, message count= 1"

"2005-08-15","17:01:01","_RecordsetPtr::Open(Select * from tblIpFaxData where MessageEntryID = '0000000015DE036E14ACE34398B00F08E0261A0507002EF3B57CF0C17A4796FDD3119D3BC2C0000000028FCF00002EF3B57CF0C17A4796FDD3119D3BC2C00000000292060000') returned [0] rows - Code: 0x80004005. Method: CIpFaxAdoHelper::GetRecordSet. [IpFaxAdoHelper.cpp::403]"

"2005-08-15","17:01:01","Caught exception - Code: 0x80004005. Method: CIpFaxAdoHelper::Execute. [IpFaxAdoHelper.cpp::357]"

"2005-08-15","17:01:01","CIpFaxAdoHelper::Execute() failed - Code: 0x80004005. Method: CIpFaxOutboundMessageData::SaveMessageRecord. [IpFaxOutboundMessage.cpp::150]"

"2005-08-15","17:01:01","SaveMessageRecord() failed - Code: 0x80004005. Method: CIpFaxOutboundMessageData::LoadMessageRecord. [IpFaxOutboundMessage.cpp::203]"

"2005-08-15","17:01:01","CIpFaxOutboundMessageData::SetMessageID() failed - Code: 0x80004005. Method: CIpFaxCdoHelper::ProcessCurrentMessage. [IpFaxMessageHelper.cpp::1224]"

"2005-08-15","17:01:01","ProcessCurrentMessage() failed - Code: 0x80004005. Method: CIpFaxCdoHelper::ProcessFaxOutbox. [IpFaxMessageHelper.cpp::682]"

"2005-08-15","17:01:01","CIpFaxCdoHelper::ProcessFaxOutbox() failed - Code: 0x80004005. Method: CIpFaxInboundRouter::ProcessFaxOutbox. [IpFaxInboundRouter.cpp::248]"

"2005-08-15","17:01:01","ProcessFaxOutbox() failed - Code: 0x80004005. Method: CIpFaxInboundRouter::MonThreadProc. [IpFaxInboundRouter.cpp::201]

I searched for the failure for hours, but I did not get any solutions. Does anybody know, how to solve this failure?

Unity-Version: 4.0(4)

Exchange 2003

Thanks in advance and greetings from Ludwigshafen/Germany

Florian Zahn

[Markus Schneider]

Hello, I'm not 100% sure what the problem is, but you might want to take a look at the SQL table since it's looking for that (long) MessageEntryID in the tblIpFaxData table (which, I believe is in the Reports database). Is there any chance that database got corrupted or is otherwise not there?

[Florian Zahn]

Hi,

thanks for you answer. I found the solution of my problem yesterday. It is not far away from idea:

The problem was with the insert-Statement into the SQL-table done by the IPFax-Service:

In the insert-Statement, there is a datevalue inserted. This insert-Statement failed, because the installation of my Unity System got a default language of german. So every system user created by default by the database also had german as default language. The SQL-database expected the date-value in the insert-statement as a value in german date-format. But the IP Fax Service produced the datevalue in us_english-dateformat. After hours of debugging and a lot of coffee, I got the solution and changed the language of all SQL-users to english. This can be done after installing the SQL-Server management tools from the Cisco Data Store 2000 CDROM with the SQL Enterprise manager.

Anyway, thanks for your help.

Greetings from Ludwigshafen,

Florian Zahn