none
Assembly was not found in the SQL catalog. RRS feed

  • Pergunta

  • Boa tarde!

    "Assembly 'pdwscliente, version=0.0.0.0, culture=neutral, publickeytoken=null.' was not found in the SQL catalog."

    Estou tendo esse erro ao executar uma procedure.

    Não sei onde fica esse "SQL catalog".

    Poderiam me ajudar?

    Obrigado!

    segunda-feira, 29 de abril de 2013 17:26

Respostas

  • Marcelo,

    Primeiro crie o Assembly. Depois crie a procedure.

    E o script enviado está mudando os nomes do assembly e da referência ao criar a procedure...

    Tente da seguinte forma:

    CREATE ASSEMBLY [SPL_CLIENTEXML]
    AUTHORIZATION [DBO]
    FROM <Binario>
    WITH PERMISSION_SET = UNSAFE
    GO
    CREATE PROCEDURE [DBO].[SPX_PROCESSAWSPA]
    	@PVCHUSER [NVARCHAR](100),
    	@PVCHPASSWORD [NVARCHAR](100),
    	@PVCHXML [NVARCHAR](MAX),
    	@PVCHXMLOUTPUT [NVARCHAR](MAX) OUTPUT
    WITH EXECUTE AS CALLER
    AS
    EXTERNAL NAME [SPL_CLIENTEXML].[PDWSCLIENTE.PDCLIENTE].[ENVIARWS]
    GO

    Espero que te ajude.

    []'s!

    • Marcado como Resposta MarceloSchneider terça-feira, 30 de abril de 2013 17:28
    segunda-feira, 29 de abril de 2013 18:40

Todas as Respostas

  • MarceloSchneider,

    Ao que me parece, esse pdwscliente é uma procedure feita em CLR, mas a DLL que faz referência à procedure não foi inserida no banco.

    []'s!

    segunda-feira, 29 de abril de 2013 17:42
  • Como faço para resolver essa pendência?
    segunda-feira, 29 de abril de 2013 17:56
  • Marcelo,

    Junto com o script dessa procedure, deve existir a script de criação do assembly (DLL) que ele utiliza.

    Vc deve rodar primeiro esse script de criação do Assembly, para ai sim depois criar a procedure.


    Se esta sugestão for útil, por favor, classifique-a como útil. Se ela lhe ajudar a resolver o problema, por favor, marque-a como Resposta.

    segunda-feira, 29 de abril de 2013 17:59
  • Mas foi exatamente isso que eu fiz, veja:

    CREATE ASSEMBLY [spl_PdclienteXML]
    AUTHORIZATION [dbo]
    FROM <Assembly> 
    WITH PERMISSION_SET = UNSAFE
    GO

    Executo este código e ele já me gera o erro:

    "Assembly 'pdwscliente, version=0.0.0.0, culture=neutral, publickeytoken=null.' was not found in the SQL catalog."

    segunda-feira, 29 de abril de 2013 18:06
  • No local de <Assembly> está um hexadecimal gigantesco.
    segunda-feira, 29 de abril de 2013 18:09
  • Marcelo,

    Me parece que você está criando o assembly com um nome diferente de pdwscliente...

    O CLR está habilitado na instância?

    A DLL é assinada? Se não, como está a permissão de inserção de DLLs não seguras?

    segunda-feira, 29 de abril de 2013 18:23
  • o CLR está habilitado sim,

    Essa DLL é criada via um hexadecimal gigantesco, segue toda procedure:

    --SP_CONFIGURE 'CLR ENABLED', 1
    --GO
    --RECONFIGURE
    --GO
    CREATE PROCEDURE [DBO].[SPX_PROCESSAWSPA]
    	@PVCHUSER [NVARCHAR](100),
    	@PVCHPASSWORD [NVARCHAR](100),
    	@PVCHXML [NVARCHAR](MAX),
    	@PVCHXMLOUTPUT [NVARCHAR](MAX) OUTPUT
    WITH EXECUTE AS CALLER
    AS
    EXTERNAL NAME [SPL_PDCLIENTE].[PDWSCLIENTE.PDCLIENTE].[ENVIARWS]
    GO
    CREATE ASSEMBLY [SPL_CLIENTEXML]
    AUTHORIZATION [DBO]
    FROM 0X4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C01030076215D4D0000000000000000E00002210B010800001C000000060000000000006E3A0000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000203A00004B00000000400000F002000000000000000000000000000000000000006000000C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000741A000000200000001C000000020000000000000000000000000000200000602E72737263000000F00200000040000000040000001E0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000002200000000000000000000000000004000004200000000000000000000000000000000503A000000000000480000000200050080250000A01400000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133005007D0000000100001102280700000A02280800000A038E690A02720100007072150000701416280900000A06163118027283000070721500007003169A740E000001280A00000A0617311802728F000070721500007003179A740E000001280A00000A0618311802729B000070721500007003189A740E000001280A00000A02280B00000A2A4602280700000A02280800000A038E69262A062A1E02280C00000A2A00000013300300840100000200001102280D00000A6F0E00000A26178D100000010A02280D00000A6F0E00000A26160B02280F00000A0C383601000002280D00000A027B02000004027B010000046F1000000A39F8000000178D110000010D02280D00000A6F1100000A2C1C02280D00000A6F1200000A02280D00000A6F0E00000A2638EA00000002280D00000A6F1300000A02280D00000A6F0E00000A2616130402280F00000A13052B7D02280D00000A6F1400000A17334D0916902D3A02280D00000A6F1500000A027B03000004332702280D00000A6F1600000A027B010000043314061602280D00000A6F1700000AA20916179C2B1A020672AD000070281800000A2B0C020672AD000070281800000A02280D00000A6F0E00000A260212041205281900000A02280D00000A6F1400000A1F0F2E1002280D00000A6F1400000A3A64FFFFFF02281A00000A2B0C0214723C010070281800000A02280D00000A6F0E00000A260212011202281900000A02280D00000A6F1400000A1F0F2E1002280D00000A6F1400000A3AABFEFFFF062A13300300860000000300001102280D00000A6F0E00000A26168D100000010A02280D00000A6F0E00000A26160B02280F00000A0C2B3E02280D00000A6F1400000A17330E020672CF010070281800000A2B0C020672CF010070281800000A02280D00000A6F0E00000A260212011202281900000A02280D00000A6F1400000A1F0F2E0D02280D00000A6F1400000A2DA6062A062A0330030052000000000000000202280D00000A6F1B00000A72150000706F1C00000A7D010000040202280D00000A6F1B00000A72D10100706F1C00000A7D020000040202280D00000A6F1B00000A72F50100706F1C00000A7D030000042A1E02281D00000A2A1A73090000062A1A73040000062A1E02281E00000A2A4603720100007072150000706F1000000A2A4A04740200000203740100001B6F010000062A1E02280C0000062A460372D101007072150000706F1000000A2A320374030000026F050000062A1E02280C0000062A4603721502007072150000706F1000000A2A4A04740200000203740100001B6F020000062A1E02280C0000062A4603723B02007072150000706F1000000A2A320374030000026F060000062A1E02280C0000062A1A73090000062A1A73040000062A0000133003004400000004000011027B040000042D35731F00000A0A06727302007072680300706F2000000A06729803007072910400706F2000000A027B040000042D0702067D04000004027B040000042A133003004400000004000011027B050000042D35731F00000A0A0672D504007072B80500706F2000000A0672DA05007072D10600706F2000000A027B050000042D0702067D05000004027B050000042A133003006400000004000011027B060000042D55731F00000A0A0672DA05007073150000066F2100000A0672D5040070730F0000066F2100000A06729803007073180000066F2100000A06727302007073120000066F2100000A027B060000042D0702067D06000004027B060000042A4603D013000001282200000A3302172A162A0A142A1E02282300000A2A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C0000001C050000237E000088050000AC06000023537472696E677300000000340C000008070000235553003C1300001000000023475549440000004C1300005401000023426C6F6200000000000000020000015715A2090900000000FA01330016000001000000140000000900000006000000200000000E00000023000000050000000400000001000000050000000500000001000000010000000300000000000A00010000000000060055013C0106006C013C01060083013C01060091013C0106007B0231010A00DC02C9020A004D0346030600A5033C010A00D503C3030A00FE03EE030A001B04EE030A00610441040A00810441040A00F104460306001B0531010A00350546030A005B0546030600F60531010E00720659060A008506460300000000010000000000010001000100100029005200050001000100010010008000520009000100050081001000A90052000D0004000A0001011000B8005200100004000D0001011000D000520010000400100001011000E90052001000040013000101100002015200100004001600010010001B01520011000400190001002602190001002F0219000100450219000100E60239000100020339000100200339005020000000008600AD010A000100D920000000008600BE010A000200EB2000000000C400D80110000300ED20000000008618E60110000300F820000000008600EC011400030088220000000086000402140003001A2300000000C400D801100003001C2300000000C4005902100003007A23000000008618E60110000300822300000000C40061021C000300892300000000C4006E02210003009023000000008418E60110000300982300000000C600850226000300AA2300000000C40094022C000400BD23000000008618E60110000600C52300000000C600850226000600D72300000000C4009E0233000700E423000000008618E60110000800EC2300000000C600850226000800FE2300000000C40094022C0009001124000000008618E60110000B00192400000000C600850226000B002B2400000000C4009E0233000C003824000000008618E60110000D00402400000000C608AA021C000D00472400000000C608B50221000D00502400000000C608F2023D000D00A02400000000C6080F033D000D00F02400000000C60831033D000D00602500000000C600520342000D00722500000000C6005F0348000E007525000000008618E60110000F0000000100BA0400000100BA04000001001506000001001F06000002003106000001001506000001003806000001001506000001001F060000020031060000010015060000010038060000010048060000010048064100E60110004900E6015E005100E60110005900E60110006100E60163006900E60110000900BC0410000900CF0410000900DF0468000900F804700009000B0510000900E60110001100AA027B0029002705800011003C05850029004C058900290063058F0029007605100029007B05100029008C0580002900990593002900A70593002900B80593001100CA0597001100D6059D001100E705100029000306B70091001106BC001100E60110001900E60110003100E601100031003F06C40031001106C40039009706CF002100E60110002E000B00D6002E001B0026012E00230026012E002B002B012E00330034017700A500B000CA000900010000006D034F0000007403540000007B03590000008703590000009403590002001900030002001A00050002001B00070002001C00090002001D000B00C1000480000001000000000000000000000000009F04000002000000000000000000000001003101000000000200000000000000000000000100C0020000000001000000000000000000000000004D060000000000000000003C4D6F64756C653E0070647773636C69656E74652E586D6C53657269616C697A6572732E646C6C00586D6C53657269616C697A6174696F6E57726974657257534175746F6D6163616F53657276696365004D6963726F736F66742E586D6C2E53657269616C697A6174696F6E2E47656E657261746564417373656D626C7900586D6C53657269616C697A6174696F6E52656164657257534175746F6D6163616F5365727669636500586D6C53657269616C697A6572310041727261794F664F626A65637453657269616C697A65720041727261794F664F626A65637453657269616C697A6572310041727261794F664F626A65637453657269616C697A6572320041727261794F664F626A65637453657269616C697A65723300586D6C53657269616C697A6572436F6E74726163740053797374656D2E586D6C0053797374656D2E586D6C2E53657269616C697A6174696F6E00586D6C53657269616C697A6174696F6E57726974657200586D6C53657269616C697A6174696F6E52656164657200586D6C53657269616C697A657200586D6C53657269616C697A6572496D706C656D656E746174696F6E005772697465315F656E76696172535041005772697465325F656E76696172535041496E4865616465727300496E697443616C6C6261636B73002E63746F720052656164315F656E76696172535041526573706F6E73650052656164325F656E76696172535041526573706F6E73654F757448656164657273006964325F4974656D006964315F656E76696172535041526573706F6E7365006964335F656E7669617253504152657475726E00496E6974494473004372656174655265616465720043726561746557726974657200586D6C5265616465720043616E446573657269616C697A650053657269616C697A6500446573657269616C697A65006765745F526561646572006765745F577269746572006D73636F726C69620053797374656D2E436F6C6C656374696F6E7300486173687461626C6500726561644D6574686F6473006765745F526561644D6574686F64730077726974654D6574686F6473006765745F57726974654D6574686F647300747970656453657269616C697A657273006765745F547970656453657269616C697A6572730053797374656D00547970650043616E53657269616C697A650047657453657269616C697A6572005265616465720057726974657200526561644D6574686F64730057726974654D6574686F647300547970656453657269616C697A65727300586D6C53657269616C697A657256657273696F6E4174747269627574650053797374656D2E5265666C656374696F6E00417373656D626C7956657273696F6E4174747269627574650053797374656D2E53656375726974790053656375726974795472616E73706172656E7441747472696275746500416C6C6F775061727469616C6C795472757374656443616C6C6572734174747269627574650053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650070647773636C69656E74652E586D6C53657269616C697A65727300700057726974655374617274446F63756D656E7400546F704C6576656C456C656D656E740057726974655374617274456C656D656E7400537472696E67005772697465456C656D656E74537472696E67005772697465456E64456C656D656E7400586D6C4E6F646554797065004D6F7665546F436F6E74656E74004F626A656374006765745F526561646572436F756E740049735374617274456C656D656E7400426F6F6C65616E006765745F4973456D707479456C656D656E7400536B697000526561645374617274456C656D656E74006765745F4E6F646554797065006765745F4C6F63616C4E616D65006765745F4E616D6573706163655552490052656164456C656D656E74537472696E6700556E6B6E6F776E4E6F646500436865636B526561646572436F756E740052656164456E64456C656D656E7400586D6C4E616D655461626C65006765745F4E616D655461626C650041646400786D6C526561646572006F626A656374546F53657269616C697A650077726974657200726561646572007365745F4974656D00747970650070647773636C69656E74650070647773636C69656E74652E646573656E765F70646170700057534175746F6D6163616F536572766963650052756E74696D655479706548616E646C65004765745479706546726F6D48616E646C6500000000001365006E007600690061007200530050004100006D68007400740070003A002F002F00770073006100750074006F006D006100630061006F002E0077006500620073006500720076006900630065002E00730075007000720069006D0065006E0074006F002E007000640063006100730065002E0063006F006D002E0062007200000B6C006F00670069006E00000B730065006E0068006100001178006D006C0045006E00760069006F0000808D68007400740070003A002F002F00770073006100750074006F006D006100630061006F002E0077006500620073006500720076006900630065002E00730075007000720069006D0065006E0074006F002E007000640063006100730065002E0063006F006D002E00620072003A0065006E007600690061007200530050004100520065007400750072006E0000809168007400740070003A002F002F00770073006100750074006F006D006100630061006F002E0077006500620073006500720076006900630065002E00730075007000720069006D0065006E0074006F002E007000640063006100730065002E0063006F006D002E00620072003A0065006E00760069006100720053005000410052006500730070006F006E00730065000001002365006E00760069006100720053005000410052006500730070006F006E0073006500001F65006E007600690061007200530050004100520065007400750072006E00002565006E00760069006100720053005000410049006E004800650061006400650072007300003765006E00760069006100720053005000410052006500730070006F006E00730065004F007500740048006500610064006500720073000080F3700064007700730063006C00690065006E00740065002E0064006500730065006E0076005F00700064006100700070002E00570053004100750074006F006D006100630061006F0053006500720076006900630065003A00530079007300740065006D002E0053007400720069006E006700200065006E0076006900610072005300500041002800530079007300740065006D002E0053007400720069006E0067002C002000530079007300740065006D002E0053007400720069006E0067002C002000530079007300740065006D002E0053007400720069006E00670029003A0052006500730070006F006E0073006500002F520065006100640031005F0065006E00760069006100720053005000410052006500730070006F006E00730065000080F7700064007700730063006C00690065006E00740065002E0064006500730065006E0076005F00700064006100700070002E00570053004100750074006F006D006100630061006F0053006500720076006900630065003A00530079007300740065006D002E0053007400720069006E006700200065006E0076006900610072005300500041002800530079007300740065006D002E0053007400720069006E0067002C002000530079007300740065006D002E0053007400720069006E0067002C002000530079007300740065006D002E0053007400720069006E00670029003A004F007500740048006500610064006500720073000043520065006100640032005F0065006E00760069006100720053005000410052006500730070006F006E00730065004F007500740048006500610064006500720073000080E1700064007700730063006C00690065006E00740065002E0064006500730065006E0076005F00700064006100700070002E00570053004100750074006F006D006100630061006F0053006500720076006900630065003A00530079007300740065006D002E0053007400720069006E006700200065006E0076006900610072005300500041002800530079007300740065006D002E0053007400720069006E0067002C002000530079007300740065006D002E0053007400720069006E0067002C002000530079007300740065006D002E0053007400720069006E006700290000215700720069007400650031005F0065006E0076006900610072005300500041000080F5700064007700730063006C00690065006E00740065002E0064006500730065006E0076005F00700064006100700070002E00570053004100750074006F006D006100630061006F0053006500720076006900630065003A00530079007300740065006D002E0053007400720069006E006700200065006E0076006900610072005300500041002800530079007300740065006D002E0053007400720069006E0067002C002000530079007300740065006D002E0053007400720069006E0067002C002000530079007300740065006D002E0053007400720069006E00670029003A0049006E00480065006100640065007200730000335700720069007400650032005F0065006E00760069006100720053005000410049006E00480065006100640065007200730000000000A2DE629F80D95443BBEC714E7BC2A93B0008B77A5C561934E089052001011D1C032000010420001D1C02060E04200012090420001205052001021215062002011C12050520011C120903061219042000121905200102121D062001120D121D042800120904280012050428001219042001010E0420010108072004010E0E1C02062003010E0E0E030701080420001215042000113D03200008052002020E0E032000020320000E052002011C0E07200201100810080A07061D1C08081D0208080607031D1C080804200012490420010E0E021D1C052002011C1C0407011219060001121D11514F01000200540E10506172656E74417373656D626C7949642561306336393731632D653530332D346136642D383731662D3834633266323762623263362C540E0756657273696F6E07322E302E302E3004010000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100483A000000000000000000005E3A0000002000000000000000000000000000000000000000000000503A00000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000940200000000000000000000940234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004F4010000010053007400720069006E006700460069006C00650049006E0066006F000000D001000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000060001F00010049006E007400650072006E0061006C004E0061006D0065000000700064007700730063006C00690065006E00740065002E0058006D006C00530065007200690061006C0069007A006500720073002E0064006C006C00000000002800020001004C006500670061006C0043006F00700079007200690067006800740000002000000068001F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000700064007700730063006C00690065006E00740065002E0058006D006C00530065007200690061006C0069007A006500720073002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E0030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000703A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    WITH PERMISSION_SET = UNSAFE
    GO

    segunda-feira, 29 de abril de 2013 18:30
  • Marcelo,

    Primeiro crie o Assembly. Depois crie a procedure.

    E o script enviado está mudando os nomes do assembly e da referência ao criar a procedure...

    Tente da seguinte forma:

    CREATE ASSEMBLY [SPL_CLIENTEXML]
    AUTHORIZATION [DBO]
    FROM <Binario>
    WITH PERMISSION_SET = UNSAFE
    GO
    CREATE PROCEDURE [DBO].[SPX_PROCESSAWSPA]
    	@PVCHUSER [NVARCHAR](100),
    	@PVCHPASSWORD [NVARCHAR](100),
    	@PVCHXML [NVARCHAR](MAX),
    	@PVCHXMLOUTPUT [NVARCHAR](MAX) OUTPUT
    WITH EXECUTE AS CALLER
    AS
    EXTERNAL NAME [SPL_CLIENTEXML].[PDWSCLIENTE.PDCLIENTE].[ENVIARWS]
    GO

    Espero que te ajude.

    []'s!

    • Marcado como Resposta MarceloSchneider terça-feira, 30 de abril de 2013 17:28
    segunda-feira, 29 de abril de 2013 18:40