升級(jí)到8.2.3后,新發(fā)OA生成不了手機(jī)圖片。
排除方法:
1、在帳套庫(kù)執(zhí)行下列語(yǔ)句
Select * from sdpo020b
2、查看下 字段 “po020b26”字段的排列順序,如果不是在 po020b25和po020b27之間,
則說(shuō)明有問(wèn)題,需執(zhí)行腳本:“sdpo020b.txt”(文件見(jiàn)附件)
3、若客戶已經(jīng)發(fā)了OA,不想重新發(fā)起,則需在帳套庫(kù)執(zhí)行下列腳本(這個(gè)視數(shù)據(jù)量大小,執(zhí)行時(shí)間相應(yīng)加長(zhǎng)):
Declare @po00402 varchar(40),
@po00403 varchar(40),
@po00418 varchar(40)
Declare sdpo004_cur Cursor For
Select po00402,po00403,po00418 From sdpo004_AllRecord Where Not Exists(
Select 1 From sdpo100 Where po10011=po00418) And Not Exists(
Select 1 From sdcf011 Where cf01105=po00418) And Not Exists(
Select 1 From sdcf027 Where cf02707=po00418) order by po00402
Open sdpo004_cur
Fetch Next From sdpo004_cur Into @po00402,@po00403,@po00418
While @@Fetch_Status<>-1
Begin
Exec InsertToImage @po00402, @po00403, @po00418
Fetch Next From sdpo004_cur Into @po00402,@po00403,@po00418
End
Close sdpo004_cur
Deallocate sdpo004_cur