• RELEVANCY SCORE 3.69

    DB:3.69:New Pricing Procedure sk





    Dear Experts,

    I define new pricing procedure instead of old procedure. now its working fine. but my doubt is

    New procedure give any error with live posting time because client previously use old procedure now i changed new procedure.

    while creating sales order my client is using BDC.........

    Any Problem. tell me

    Thanks in advance

    DB:3.69:New Pricing Procedure sk


    Your comment -
    think there s no link between pricing procedure and billing.....

  • RELEVANCY SCORE 3.57

    DB:3.57:Error While Creating Pas Procedure x8





    Dear Friends

    I am getting following error while creating PAS procedure. I login using Admin

    Access to Database Admin.EWK Denied by the Operating System

    What might be the reason for this error?

    Rgds

    SriG


    DB:3.57:Error While Creating Pas Procedure x8


    Hi experts!!

    I find myself in the same situation, Im working on a Linux Server, any other possible solution to this problem?

    Thanks!!

  • RELEVANCY SCORE 3.56

    DB:3.56:Error While Executing Multiple Stored Procedure Through .Sql File 81




    Hi Guru's.

    I am new to ORACLE. I am facing problem while creating Stored Procedure through .sql file.

    I have one test.sql file with Stored Procedure is like,

    CREATE OR REPLACE PROCEDURE skeleton1
    AS
    BEGIN
    DBMS_Output.Put_Line('skeleton1');
    END skeleton1;
    /
    CREATE OR REPLACE PROCEDURE skeleton2
    AS
    BEGIN
    DBMS_Output.Put_Line('skeleton2');
    END skeleton2;
    /

    Now when i try to execute this test.sql file through SQL PLUS it gives me Error like this

    I am opening test.sql file from SQL PLUS,

    SQL
    1 CREATE OR REPLACE PROCEDURE skeleton1
    2 AS
    3 BEGIN
    4 DBMS_Output.Put_Line('skeleton1');
    5 END skeleton1;
    6 /
    7 CREATE OR REPLACE PROCEDURE skeleton2
    8 AS
    9 BEGIN
    10 DBMS_Output.Put_Line('skeleton2');
    11* END skeleton2;
    SQL /

    Warning: Procedure created with compilation errors.

    SQL show errors;
    Errors for PROCEDURE SKELETON1:

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    6/1 PLS-00103: Encountered the symbol "/"
    SQL

    Please suggest how to create multiple CREATE PROCEDURE using single .sql script file....

    Regards,
    Shatrughan

  • RELEVANCY SCORE 3.52

    DB:3.52:Error While Creating Pourchase Order sm



    I am getting following error while creating PO

    ___

    Account assignment mandatory for material 000000000000001335 (enter acc. ***. cat.)

    Message no. ME062

    Diagnosis

    There is no provision for value-based inventory management for this material type in this plant. Account assignment is thus necessary.

    Procedure

    Please enter an account assignment category.

    __

    Please help

    Regards

    Ranjeey

    DB:3.52:Error While Creating Pourchase Order sm


    hi,

    As you are mentioning Material Type is -HAWA

    Hawa material will have Valuation class as -Trading material

    If we have Not ticked -Value and Qty updating for the HAWA material type then eventhrough we maintain Accounting Views. -In configuration

    We get the error as a account assignment cat mandatory.

    Please maintain Qty and Value update Tick then you can create PO

    with regards

    Shrinivas gangoor

  • RELEVANCY SCORE 3.52

    DB:3.52:Transaction Type Does Not Exist 7s



    While creating PR PO for the Assets I am getting Following Error

    Transaction type does not exist

    Message no. AA_BAS_CUS_READ008

    Diagnosis

    The transaction type entered does not exist.

    System Response

    Processing is terminated.

    Procedure

    Check your entry.

    Can any body please help me to make PR PO.

    Amit

    DB:3.52:Transaction Type Does Not Exist 7s


    This may be the issue with field status for Reconcialiation account. Please check. It may be just that.

  • RELEVANCY SCORE 3.47

    DB:3.47:Loadjava zp


    --
    I created a stored procedure with the JDeveloper 2.0. As I tried
    to load the class into a 8i database (Solaris 2.6), I got the
    following error message.

    $ loadjava -user scott/tiger@myhost:1521:testdb -v -t
    DBMathBenchmark.class
    initialization complete
    loading : DBMathBenchmark
    creating : DBMathBenchmark
    Error while creating class DBMathBenchmark
    Exception java.sql.SQLException: No more data to read from
    socket
    loadjava: 1 errors
    $

    What might be the reason for this failure?

    Thanks, Matthias
    null

    DB:3.47:Loadjava zp

    --
    Matthias , this can either be a jdbc or a server error.
    one can try loadjava -debug to see where it is failing.

    -JDeveloper Team

    Matthias Voigt (guest) wrote:
    : I created a stored procedure with the JDeveloper 2.0. As I
    tried
    : to load the class into a 8i database (Solaris 2.6), I got the
    : following error message.
    : $ loadjava -user scott/tiger@myhost:1521:testdb -v -t
    : DBMathBenchmark.class
    : initialization complete
    : loading : DBMathBenchmark
    : creating : DBMathBenchmark
    : Error while creating class DBMathBenchmark
    : Exception java.sql.SQLException: No more data to read from
    : socket
    : loadjava: 1 errors
    : $
    : What might be the reason for this failure?
    : Thanks, Matthias
    null

  • RELEVANCY SCORE 3.42

    DB:3.42:Tax Code In Procedure Taxpmt Is Invalid aa



    Hi Friends,

    Can your pl. help me in solving the above error generated while creating billing document in t code vf02. The error message no. is FICORE704.

    Thanks regards,

    Ranjeet

    DB:3.42:Tax Code In Procedure Taxpmt Is Invalid aa


    Dear Ranjeet,

    Please try one of the following points:

    (a) In Spro-Tax on sales/Purchases-bAssign country to calculation procedure/b Check if this is defined.

    (b)

    In bFTXP/b(Maintain tax code)

    I) Give the tax code "XY" and enter

    ii) A pop box will come give there the description of the tax code Tax type whether input or output then press enter

    iii) ON the right you will find the condition type's name see the tax procedure and check for which condition type you are going to maintain tax code then in front of same condition type give the percentage. Then on the header click tax accounts button give the GL account in which the posting should be done. Finally save your data.

    (c)

    IN Spro-Tax on sales/Purchases-bAssign Tax codes for non-taxable transaction/b is defined.

    Kindly have a look at this thread containing the solution for the same issue:

    bRe: Tax code VN in procedure TAXUSJ is invalid/b

    bKindly let me know if it is useful/b

    Regards,

    Mary Sofia

  • RELEVANCY SCORE 3.40

    DB:3.40:Problem While Creating Table Dynamically Using Stored Procedure fk


    Hi all

    When i try to execute the following lines get insufficient privilege error.

    FYI: i m able to create table statically.(i.e without using stored procedure)

    CREATE OR REPLACE PROCEDURE pcalling IS

    str varchar2(60);

    BEGIN

    str:='create table t15(tno number,tname varchar2(5))';

    execute immediate str;

    END;

    /

    Thanks in advance

    Satya

  • RELEVANCY SCORE 3.39

    DB:3.39:Foreach Loop Erro While Creating Procedure? 1f


    hello all, i am creating a proceudre with foreach loop, created with compilation error. please correct me if some mistake is there...

    CREATE PROCEDURE update_list
    DEFINE name VARCHAR(30);
    DEFINE address VARCHAR(255);
    begin
    FOREACH namedCursor FOR
    SELECT ename, eaddress INTO name, address FROM emp
    INSERT INTO mailing_list VALUES(name, address);
    IF(ename="McAllister") THEN
    UPDATE emp SET sal = sal + 2000 WHERE CURRENT OF namedCursor;
    CONTINUE FOREACH;
    END IF
    UPDATE emp SET sal = sal + 1000 WHERE CURRENT OF namedCursor;
    END FOREACH;
    END PROCEDURE

    thanks
    yash

    mailing_list table is created with field.

    DB:3.39:Foreach Loop Erro While Creating Procedure? 1f

    Triple post - here is the answered thread: {thread:id=2272279}

  • RELEVANCY SCORE 3.38

    DB:3.38:Report Viewer 9x


    Hi

    i get the following error message while accessing the stored procedure

    How to provide the DBO role in creating the stored procedure from visual studio from the data set

    - Ram

    DB:3.38:Report Viewer 9x

    Hello David,
    Thank you for your post.
    If your issue is how to provide the DBO role in creating the stored procedure from VS from the data set, I do a research and find it is more based on ASP.NET.

    See: http://forums.asp.net/t/1850222.aspx/1

    http://www.asp.net/web-forms/tutorials/data-access/advanced-data-access-scenarios/using-existing-stored-procedures-for-the-typed-dataset-s-tableadapters-vb
    If you are working with ASP.NET, I am afraid that the issue is out of support of VS General Question forum which mainly discusses
    WPF SL designer, Visual Studio Guidance Automation Toolkit, Developer Documentation and Help System
    and Visual Studio Editor.

    I suggest that you can consult your issue directly on ASP.NET forum:
    http://forums.asp.net/ for better solution and support.
    If I have misunderstood anything, please feel free to let me know.
    Best regards,Amanda Zhu [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.37

    DB:3.37:Customer Master kz



    Hi,

    While creating the customer master iam getting the warning message that Calculation Procedure is not assigned to IN. Plz let me know where we assign the calculation procedure?

    When i am creating the customer in XD01 i am getting the error that customer number 6001 does not exist. I am using the internal assignment here which ranges from 6001 to 8001. why iam getting this error?

    Thanks

    DB:3.37:Customer Master kz


    HI

    First Tax Calculation Procedure need to be assigned to the Country IN. Please follow below steps.

    SPRO IMG Financial AccountingTax on Sales/Purchases Assign Country to Calculation Procedure

    If the Calculation Procedure is not defined, it needs to be defined first.

    Further go to OVKK and assign the sales area to the the condition type and pricing procedure.

  • RELEVANCY SCORE 3.37

    DB:3.37:Ecatt Error During Ip04 Run mf



    Dear All,

    I am finding one error in running the Esecatt

    I have created template for creating Maintenance item for t code Ip04 ,By Secatt

    I have created template as per std procedure in secatt

    Like first creation of test script then creating test configuration

    after creating the template we have entered the data

    Now following error is giving while creating the secatt

    Error in ecatt command TCD IP04

    EIP328 Enter an order type

    but we have already entered the order type as GPM (Generated prevetivte maint order type)

    what could be the reason

    Regards

    chand

    DB:3.37:Ecatt Error During Ip04 Run mf


    Dear all

    It was an Data error

    thanks

    chand

  • RELEVANCY SCORE 3.37

    DB:3.37:Ora-06502: Pl/Sql: Numeric Or Value Error In Package Xle_Legal_Address_Swi Procedure Create_Legal_Address zf


    Dear Experts,When I try to create New Address while creating New Legal Entity , I get the following Error:ORA-06502: PL/SQL: numeric or value error in Package xle_legal_address_swi Procedure create_legal_addressI need you help please,Ahmad,

  • RELEVANCY SCORE 3.36

    DB:3.36:Error 29000: Urgent - Help sa


    TFS 2008 install
    Single Server installation
    Services account : sv00033
    Reports account : same as above (sv00033)
     
     
    We got the
     
    Error 29000: Team foundation server database could not be installed. Please check the msi log for more details.
     
    On checking the msi log, I found out that the service account was not added to the security  in the Analysis server.So, we added the sv00033 (service account) and restarted the SQL server and the analysis server.
     
    I also added Everyone to have full rights in the install folder (We are installing on D:\Program Files\Microsoft Visual Studio 2008 Team foundation server).
    Still the same error.
    Any help/pointers?? This is very urgent.
     
    Beginning deployment of data tier: TfsWorkItemTracking********************************************************************* PLEASE IGNORE ALL SYSDEPENDS AND KEY MAX LENGTH WARNINGS ******************************************************************** Stamping the product to_version 9.0.21022.8 on TfsWorkItemTracking creating tables for PS Objects creating db only views of content.sql for PS Objects End of __CreateDependentViews.sql file End of __CreateWideViews.sql file creating full text index for WIT Objects Creating full text index on Workitem Creating Linking sprocs - Nov 28 2007 11:40AM creating mid tier also views of inside.sql creating UDFs of dal.sql creating sprocs of inside.sql End of inside.sql file Creating SADCache sprocs - Nov 28 2007 11:40AM Creating SyncWithAD_Lookup Creating SyncWithAD_ChangeADObject Creating SyncWithAD_GetADObject Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.GetAccountDisplayMode'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists. Warning! The maximum key length is 900 bytes. The index 'UQ__#0842AE22__0A2AF694' has maximum length of 1029 bytes. For some combination of large values, the insert/update operation will fail.Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.GetAccountDisplayMode'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists. creating PS Object DAL primitives UDFs of dal.sql creating WIT Object full text UDFs of dal.sql creating sprocs of dal.sql Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.GetAccountDisplayMode'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists. Caution: Changing any part of an object name could break scripts and stored procedures.Caution: Changing any part of an object name could break scripts and stored procedures.Caution: Changing any part of an object name could break scripts and stored procedures.Caution: Changing any part of an object name could break scripts and stored procedures.Caution: Changing any part of an object name could break scripts and stored procedures. End of inthebox.sql filecreating PS Object DAL primitives sprocs of dal.sql Creating Procedure ClearInstanceInfo Creating Procedure GetInstanceInfo Creating Procedure SetInstanceInfo creating UDFs of dal.sql creating UDFs of dal.sql Creating Procedure prc_EnableDBUser Stamping DB...********************************************************************* PLEASE IGNORE ALL SYSDEPENDS AND KEY MAX LENGTH WARNINGS ********************************************************************Completed deployment of data tier TfsWorkItemTrackingCopying the schema version to 9.20904.00 on TfsWorkItemTracking Stamping the product version to 9.0.21022.8 on TfsWorkItemTracking Adding the account DoneCreating the Work Item Tracking Attachments Database Creating the Work Item Tracking Attachments Database (TfsWorkItemTrackingAttachments) attachments.tsq Creating the data deployer Creating the database Changed database context to 'master'. Running the script Halting condition evaluation for the remainder of the script. Stamping the product to_version 9.0.21022.8 on TfsWorkItemTrackingAttachments Creating Procedure prc_EnableDBUser Copying the schema version to 9.20904.00 on TfsWorkItemTrackingAttachments Stamping the product version to 9.0.21022.8 on TfsWorkItemTrackingAttachments Adding the account DoneCreating the Reporting Database Creating the Reporting Database (TfsWarehouse) D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe -setup -install -n -s HOUMSQL330 -d TfsWarehouse -c D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml -a HALHOUSTON\sv00033 -ra HALHOUSTON\sv00033 -asinst HOUMSQL330 -asdbname TfsWarehouse -asacct  D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe -setup -install -n -s HOUMSQL330 -d TfsWarehouse -c D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml -a HALHOUSTON\sv00033 -ra HALHOUSTON\sv00033 -asinst HOUMSQL330 -asdbname TfsWarehouse -asacct  An unexpected error occurred when connecting to the Analysis Server. Check that your Analysis Server is up and you have sufficient privileges on it: File system error: The following error occurred during a file operation:  Access is denied. . 4 D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 4 40985 Microsoft.TeamFoundation.DatabaseInstaller.DatabaseException: D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 4 40985   at Microsoft.TeamFoundation.DatabaseInstaller.ProcessDeployer.ExecuteCommand(String filePath, String arguments, Boolean continueOnError)Microsoft.TeamFoundation.DatabaseInstaller.DatabaseException: D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 4 40985   at Microsoft.TeamFoundation.DatabaseInstaller.ProcessDeployer.ExecuteCommand(String filePath, String arguments, Boolean continueOnError)   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.RunDbActions(InstallerMode mode, String server, Boolean preview)   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.RunSteps(InstallerMode mode, String server, IPropertyCollection properties, Boolean preview)   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.Install(String server, IPropertyCollection properties, Boolean preview)   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.Commands.CommandInstall.OnRun()   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.Commands.InstallerCommand.Run()   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.CommandLine.RunCommand(String args)
    D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 4 4098511/28/07 11:41:19 DDSet_Status: Process returned 10011/28/07 11:41:19 DDSet_Status: Using default error code for return value '100' and it is: '29000'11/28/07 11:41:19 DDSet_Error:  100MSI (s) (C0!64) [11:41:25:956]: Product: Microsoft Visual Studio 2008 Team Foundation Server - ENU -- Error 29000.The Team Foundation databases could not be installed. For more information, see the Microsoft Windows Installer (MSI) log.
    11/28/07 11:41:25 DDSet_Status: Commandline: D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\TfsDb.exe install /server:HOUMSQL330 /property:TFS_SERVICE_ACCOUNT=HALHOUSTON\sv00033;TFS_REPORTING_ACCOUNT=HALHOUSTON\sv00033;LCID=1033;VSTF_AS_INSTANCE=HOUMSQL330;VSTF_AS_DATABASE=TfsWarehouse;VSTF_AS_ACCOUNT= /showui:6582811/28/07 11:41:25 DDSet_Status: IgnoreExitCode: 011/28/07 11:41:25 DDSet_Status: Silent: 011/28/07 11:41:25 DDSet_Status: ActionStart: 011/28/07 11:41:25 DDSet_Status: Cost: 011/28/07 11:41:25 DDSet_Status: WorkingDirectory: 11/28/07 11:41:25 DDSet_Status: HideCmdLine: 0TfsDb - Team Foundation Server Database UtilityCopyright (c) Microsoft Corporation.  All rights reserved.
     ='HALHOUSTON\sv00033' ='HALHOUSTON\sv00033' ='1033' HOUMSQL330='HOUMSQL330' TfsWarehouse='TfsWarehouse' ='' ='HOUMSQL330' ='D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools' ='' ='TFSEXECROLE'Extracting Files DoneClosing existing database connections Killing connections to TfsActivityLogging database Killing connections to TfsIntegration database Killing connections to TfsVersionControl database Killing connections to TfsWorkItemTracking database Killing connections to TfsBuild database Killing connections to TfsWarehouse database Killing connections to TfsWorkItemTrackingAttachments databaseInitializing...Creating the Version Control Database Creating the Version Control Database (TfsVersionControl) HatterasCreateSchema.sql Creating the data deployer Creating the database Changed database context to 'master'. Running the script Halting condition evaluation for the remainder of the script. Stamping the product to_version 9.0.21022.8 on TfsVersionControl Warning! The maximum key length is 900 bytes. The index 'IX_tbl_tmpBranch_SpIdTargetServerItem' has maximum length of 1044 bytes. For some combination of large values, the insert/update operation will fail. Warning! The maximum key length is 900 bytes. The index 'IX_tbl_tmpPendingMerge_SpIdTargetServerItem' has maximum length of 1048 bytes. For some combination of large values, the insert/update operation will fail. Warning! The maximum key length is 900 bytes. The index 'PK__#38B0DB53__39A4FF8C' has maximum length of 1044 bytes. For some combination of large values, the insert/update operation will fail. Warning! The maximum key length is 900 bytes. The index 'PK__#46FEFAAA__47F31EE3' has maximum length of 1040 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_AddLocalConflict Creating Procedure prc_CheckIn Warning! The maximum key length is 900 bytes. The index 'PK__#5A11CF1E__5B05F357' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#5BFA1790__5CEE3BC9' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_CheckPendingChanges Warning! The maximum key length is 900 bytes. The index 'PK__#61B2F0E6__62A7151F' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_CreateDelta Creating Procedure prc_CreateIdentity Creating Procedure prc_CreateLabel Creating Procedure prc_CreateRecursiveLabel Creating Procedure prc_CreateTeamProject Creating Procedure prc_CreateWorkspace Creating Procedure prc_CreateWorkspaceLabel Creating Procedure prc_CreateWorkspaceLabelLocal Creating Procedure prc_DeleteAnnotation Creating Procedure prc_DeleteIdentity Creating Procedure prc_DeleteLabel Creating Procedure prc_DeletePendingDelta Creating Procedure prc_DeleteShelveSet Creating Procedure prc_DeleteUnusedContent Creating Procedure prc_DeleteUnusedVersionedItems Creating Procedure prc_DeleteUnusedLobParameters Creating Procedure prc_DeleteWorkspace Creating Procedure prc_Destroy Creating Procedure prc_DetermineLocalItemType Creating Procedure prc_DetermineServerItemType Creating Procedure prc_EnableDBUser Creating Procedure prc_FindChangeSetByDate Creating Procedure prc_FindItemLocal Creating Procedure prc_FindLabelByLabelId Creating Procedure prc_FindLatestChangeSet Creating Procedure prc_FindPendingChangeById Warning! The maximum key length is 900 bytes. The index 'PK__#676BCA3C__685FEE75' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_Get Warning! The maximum key length is 900 bytes. The index 'PK__#6B3C5B20__6C307F59' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#6D24A392__6E18C7CB' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_iCheckLockStatus Creating Procedure prc_iFindLabel Creating Procedure prc_iFindWorkspace Creating Procedure prc_iGetLastChangeSet Creating Procedure prc_QueryFileContents Creating Procedure prc_iCalculateBulkMergeLocks Creating Procedure prc_iiComputeWorkspaceMappings Creating Procedure prc_iiCreateIdentity Creating Procedure prc_iiCreateLabel Creating Procedure prc_iiCreatePendingChange Creating Procedure prc_iiDeleteIdentity Creating Procedure prc_iiDeletePendingChangesRecursive Creating Procedure prc_iiDeleteWorkspace Creating Procedure prc_iiGenerateLabelEntries Creating Procedure prc_iiInstallData Creating Procedure prc_iiInstallMessages Creating Procedure prc_iiLockItem Creating Procedure prc_iiPendConflict Warning! The maximum key length is 900 bytes. The index 'PK__#75B9E993__76AE0DCC' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_iiPendRename Warning! The maximum key length is 900 bytes. The index 'PK__#7A7E9EB0__7B72C2E9' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_iiPendUndelete Warning! The maximum key length is 900 bytes. The index 'PK__#7C66E722__7D5B0B5B' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_iiPendUnshelve Creating Procedure prc_iiResolveMergeConflict Warning! The maximum key length is 900 bytes. The index 'PK__#040808EA__04FC2D23' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating procedure prc_iiResolveNamespaceConflict Warning! The maximum key length is 900 bytes. The index 'PK__#05F0515C__06E47595' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#07D899CE__08CCBE07' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating procedure prc_iiResolveVersionConflict Creating Procedure prc_iiSetPermission Creating Procedure prc_iiSetRenameState Creating Procedure prc_iiSetWorkingFolders Creating Procedure prc_iiUndoPendingChanges Warning! The maximum key length is 900 bytes. The index 'PK__#0AB50679__0BA92AB2' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#0C9D4EEB__0D917324' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_iiUploadFile Creating Procedure prc_iMapLocalToServerItem Creating Procedure prc_iMapServerToLocalItem Creating Procedure prc_iParseVersionSpec Creating Procedure prc_iUpdateLocalVersion Creating Procedure prc_LockItem Creating Procedure prc_OptimizeDatabase Creating Procedure prc_PendAdd Creating Procedure prc_PendDelete Warning! The maximum key length is 900 bytes. The index 'PK__#190325D0__19F74A09' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_PendEdit Creating Procedure prc_PendMerge Warning! The maximum key length is 900 bytes. The index 'PK__#1DC7DAED__1EBBFF26' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#1FB0235F__20A44798' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_PendRename Creating Procedure prc_PendUndelete Creating Procedure prc_PendUnshelve Creating Procedure prc_PrepareMerge Creating Procedure prc_PrepareUnshelve Creating Procedure prc_QueryAnnotation Creating Procedure prc_QueryBranches Creating Procedure prc_QueryChangeSet Creating Procedure prc_QueryConflicts Warning! The maximum key length is 900 bytes. The index 'PK__#2B21D60B__2C15FA44' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_QueryEncodings Creating Procedure prc_QueryFileTypes Creating Procedure prc_QueryHistory Creating Procedure prc_QueryIdentitySID Creating Procedure prc_QueryIdentityDisplayName Creating Procedure prc_QueryItems Creating Procedure prc_QueryItemsExtended Warning! The maximum key length is 900 bytes. The index 'PK__#2DFE42B6__2EF266EF' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_QueryItemsExtendedLocal Warning! The maximum key length is 900 bytes. The index 'PK__#30DAAF61__31CED39A' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#33B71C0C__34AB4045' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_QueryItemsLocal Creating Procedure prc_QueryLabels Creating Procedure prc_QueryLabelItems Creating Procedure prc_QueryLabelItemsLocal Warning! The maximum key length is 900 bytes. The index 'PK__#359F647E__369388B7' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_QueryMappedItems Warning! The maximum key length is 900 bytes. The index 'PK__#3787ACF0__387BD129' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_QueryMerges Creating Procedure prc_QueryPendingChanges Warning! The maximum key length is 900 bytes. The index 'PK__#42053B63__42F95F9C' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#43ED83D5__44E1A80E' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_QueryPendingDeltas Creating Procedure prc_QueryRepositories Creating Procedure prc_QueryRepositoryInformation Creating Procedure prc_QuerySecurityObjects Creating Procedure prc_QueryServerItemsByItemIds Creating Procedure prc_QueryShelvesets Creating Procedure prc_QueryWorkspaceItems Warning! The maximum key length is 900 bytes. The index 'PK__#49A65D2B__4A9A8164' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#4C82C9D6__4D76EE0F' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_QueryWorkspaceItemsLocal Warning! The maximum key length is 900 bytes. The index 'PK__#4F5F3681__50535ABA' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.Warning! The maximum key length is 900 bytes. The index 'PK__#51477EF3__523BA32C' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail. Creating Procedure prc_QueryWorkspaces Creating Procedure prc_MapLocalToServerItem Creating Procedure prc_RemoveLocalConflict Creating procedure prc_Resolve Creating Procedure prc_SetAnnotation Creating Procedure prc_SetDeltaRetryCount Creating Procedure prc_SetFileTypes Creating Procedure prc_SetItemPermission Creating Procedure prc_SetPermission Creating Procedure prc_SetPermissionInheritance Creating Procedure prc_Shelve Creating Procedure prc_UndoPendingChange Creating Procedure prc_UpdateChangeSet Creating Procedure prc_UpdateIdentityDisplayName Creating Procedure prc_UpdateIdentitySID Creating Procedure prc_UpdateLabel Creating Procedure prc_UpdateLobParameter Creating Procedure prc_UpdateLocalVersion Creating Procedure prc_UpdateRevertTo Creating Procedure prc_UpdateWorkspace Creating Procedure prc_UploadFile Creating Procedure prc_UpdateDownloadKey Creating Procedure ClearInstanceInfo Creating Procedure GetInstanceInfo Creating Procedure SetInstanceInfo Creating Procedure prc_Install Creating Procedure prc_CreateReleaseNote Creating Procedure prc_CreateReleaseNoteDefinition Creating Procedure prc_QueryReleaseNote Creating Procedure prc_QueryReleaseNoteDefinition Creating Procedure prc_QueryReleaseNoteFieldNames Creating Procedure prc_UpdateReleaseNoteFieldDefinition Copying the schema version to 9.20904.00 on TfsVersionControl Stamping the product version to 9.0.21022.8 on TfsVersionControl Adding the account DoneCreating the Activity Logging Database Creating the Activity Logging Database (TfsActivityLogging) AdministrationSchema.sql Creating the data deployer Creating the database Changed database context to 'master'. Running the script Halting condition evaluation for the remainder of the script. Stamping the product to_version 9.0.21022.8 on TfsActivityLogging Creating Procedure prc_LogActivity Creating Procedure prc_CreateCommand Creating Procedure prc_PruneCommands Creating Procedure prc_EnableDBUser Copying the schema version to 9.20904.00 on TfsActivityLogging Stamping the product version to 9.0.21022.8 on TfsActivityLogging Adding the account DoneCreating the Build Database Creating the Build Database (TfsBuild) teambuilddb.sql Creating the data deployer Creating the database Changed database context to 'master'. Running the script Halting condition evaluation for the remainder of the script. Stamping the product to_version 9.0.21022.8 on TfsBuild Warning! The maximum key length is 900 bytes. The index 'PK__#03D2FEC0__04C722F9' has maximum length of 1040 bytes. For some combination of large values, the insert/update operation will fail. Creating procedure prc_iGetBuildId Creating procedure prc_iSplitQueryPath Creating procedure prc_iiAddBuildGroup Creating procedure prc_iiAddBuildQualities Creating procedure prc_iiEnsureDefaultGroups Creating procedure prc_iiGetAffectedBuildDefinitions Creating procedure prc_iiStartBuilds Creating procedure prc_iiUpdateBuildInformation Creating procedure prc_iiPortTestRunInformation Creating procedure prc_iiPortBuildCoverageInformation Creating procedure prc_AddBuild Creating procedure prc_AddBuildAgents Creating procedure prc_AddBuildDefinitions Creating procedure prc_AddBuildQualities Creating procedure prc_CancelBuilds Creating procedure prc_DeleteBuildAgents Creating procedure prc_DeleteBuildDefinitions Creating procedure prc_DeleteBuildQualities Creating procedure prc_DeleteBuilds Creating procedure prc_DeleteOldQueueItems Creating procedure prc_DeleteTeamProject Creating procedure prc_DeleteUnnecessaryBuildInformation Creating Procedure prc_EnableDBUser Creating procedure prc_EvaluateRetentionPolicy Creating procedure prc_GetAffectedBuildDefinitions Creating procedure prc_GetBuildQualities Creating procedure prc_GetListOfBuildsForUpload Creating procedure prc_GetPlatformFlavorsBuilt Creating procedure prc_GetQueueObjects Creating procedure prc_GetUnverifiedBuildQualities Creating procedure prc_iiInstallData Creating Procedure prc_iiInstallMessages Creating procedure prc_iiQueueBuilds Creating procedure prc_ProcessChangeset Creating procedure prc_QueryBuildAgents Creating procedure prc_QueryBuildAgentsByUri Creating procedure prc_QueryBuildDefinitions Creating procedure prc_QueryBuildDefinitionsByUri Creating procedure prc_QueryBuilds Creating procedure prc_QueryBuildsByUri Creating procedure prc_QueueBuild Creating procedure prc_QueryQueue Creating procedure prc_QueryQueueById Creating procedure prc_StartBuild Creating procedure prc_StartPendingBuilds Creating procedure prc_UpdateBuildAgents Creating procedure prc_UpdateBuildDefinitions Creating procedure prc_UpdateBuildInformation Creating procedure prc_UpdateBuilds Creating procedure prc_UpdateLastUploadedBuild Creating procedure prc_UpdateQueuedBuilds Creating procedure prc_VerifyBuildQualities Creating Procedure ClearInstanceInfo Creating Procedure GetInstanceInfo Creating Procedure SetInstanceInfo Creating procedure prc_Install Creating procedure prc_CancelRunPublishing Creating procedure prc_CheckUpdateRunState Creating procedure prc_GetBuildUris Creating procedure prc_GetPlatformFlavorId Creating procedure prc_GetRunInformation Creating procedure prc_RemoveRunData Creating procedure prc_RetrieveRunCoverageForBuild Creating procedure prc_RetrieveRunsForBuild Creating procedure prc_UpdateRunState Copying the schema version to 9.20904.00 on TfsBuild Stamping the product version to 9.0.21022.8 on TfsBuild Adding the account DoneInitializing the Database Initializing the Database (TfsBuild) exec dbo.prc_Install DoneCreating the Integration Database Creating the Integration Database (TfsIntegration) BisCreateSchema.sql Creating the data deployer Creating the database Changed database context to 'master'. Running the script Halting condition evaluation for the remainder of the script.   Stamping the product to_version 9.0.21022.8 on TfsIntegration Creating Procedure prc_EnableDBUser Creating Procedure prc_install_messages Creating Procedure prc_OptimizeDatabase Creating Procedure Prc_OptimizeTfsDatabases Creating Function fn_gss_sid_member_of_group Creating Procedure prc_ii_gss_create_group Creating Procedure  prc_security_read_is_member Creating Procedure prc_ii_gss_add_group_member Creating Procedure  prc_ii_security_delete_identities Creating Procedure prc_ii_security_remove_group_member Creating Procedure prc_ii_security_delete_ace Creating Procedure prc_ii_security_create_ace Creating Procedure  prc_ii_security_register_object Creating Procedure  prc_ii_security_register_project Creating Procedure  prc_ii_security_unregister_object Creating Procedure  prc_ii_security_unregister_project Creating Procedure  prc_get_server_status Creating Procedure  prc_update_server_status Creating Procedure ClearInstanceInfo Creating Procedure GetInstanceInfo Creating Procedure SetInstanceInfo Creating Procedure prc_gss_add_group_member Creating Procedure prc_gss_create_group Creating Procedure prc_gss_find_group_by_sid Creating Procedure prc_gss_find_group_by_display_name Creating Procedure prc_gss_find_groups Creating Procedure prc_gss_find_groups_by_special_type Creating Procedure prc_gss_install Creating Procedure prc_gss_remove_group Creating Procedure prc_gss_remove_group_member Creating Procedure prc_gss_update_group Creating Procedure prc_security_create_ace Creating Procedure prc_security_delete_ace Creating Procedure  prc_security_delete_identity Creating Procedure prc_security_get_changed_acls Creating Procedure prc_security_get_changed_identities Creating Procedure  prc_security_get_class_actions Creating Procedure  prc_security_get_classes Creating Procedure  prc_security_get_object_class Creating Procedure  prc_security_get_sid Creating Procedure prc_security_install Creating Procedure  prc_security_list_groups Creating Procedure  prc_security_permission_cache_insert Creating Procedure  prc_security_permission_cache_read Creating Procedure prc_security_read_acl Creating Procedure  prc_security_read_identity Creating Procedure prc_security_read_is_permitted Creating Procedure  prc_security_register_object Creating Procedure  prc_security_register_project Creating Procedure  prc_security_set_inheritance Creating Procedure  prc_security_unregister_object Creating Procedure prc_security_unregister_project Creating Procedure  prc_security_update_identities Creating Procedure  prc_security_update_identity Creating Procedure prc_security_update_sidEàCreating Procedure prc_css_get_node Creating Procedure prc_css_get_node_from_path Creating Procedure prc_css_get_nodes Creating Procedure prc_css_get_root_nodes Creating Procedure prc_css_get_project Creating Procedure prc_css_get_project_from_name Creating Procedure prc_css_get_project_properties Creating Procedure prc_css_get_projects Creating Procedure prc_css_get_projects_from_state Creating Procedure prc_ii_css_create_node Creating Procedure prc_ii_css_create_project Creating Procedure prc_ii_css_move_node Creating Procedure prc_ii_css_rename_node Creating Procedure prc_ii_css_delete_node Creating Procedure prc_ii_css_delete_project Creating Procedure prc_css_install Creating Procedure prc_css_create_node Creating Procedure prc_css_create_project Creating Procedure prc_css_move_node Creating Procedure prc_css_rename_node Creating Procedure prc_css_reorder_node Creating Procedure prc_css_delete_node Creating Procedure prc_css_delete_project Creating Procedure prc_css_get_changed_nodes Creating Procedure prc_css_get_deleted_nodes Creating Procedure prc_AdminCheckUserPermissions Calling prc_install_messages Calling prc_gss_install Calling prc_security_install Calling prc_css_install Did 0 conversions. Copying the schema version to 9.20904.00 on TfsIntegration Stamping the product version to 9.0.21022.8 on TfsIntegration Adding the account DoneInitializing the Database Initializing the Database (TfsIntegration) exec prc_install_messages;  exec prc_gss_install DoneCreating the Work Item Tracking Database Creating the Work Item Tracking Database (TfsWorkItemTracking) schema.tsq Creating the data deployer Creating the database Changed database context to 'master'. Running the script Halting condition evaluation for the remainder of the script. 
    // This file is automatically updated by PSBUILD. Do NOT edit!!
     
     
    Beginning deployment of data tier: TfsWorkItemTracking********************************************************************* PLEASE IGNORE ALL SYSDEPENDS AND KEY MAX LENGTH WARNINGS ******************************************************************** Stamping the product to_version 9.0.21022.8 on TfsWorkItemTracking creating tables for PS Objects creating db only views of content.sql for PS Objects End of __CreateDependentViews.sql file End of __CreateWideViews.sql file creating full text index for WIT Objects Creating full text index on Workitem Creating Linking sprocs - Nov 28 2007 11:42AM creating mid tier also views of inside.sql creating UDFs of dal.sql creating sprocs of inside.sql End of inside.sql file Creating SADCache sprocs - Nov 28 2007 11:42AM Creating SyncWithAD_Lookup Creating SyncWithAD_ChangeADObject Creating SyncWithAD_GetADObject Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.GetAccountDisplayMode'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists. Warning! The maximum key length is 900 bytes. The index 'UQ__#754FD53F__77381DB1' has maximum length of 1029 bytes. For some combination of large values, the insert/update operation will fail.Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.GetAccountDisplayMode'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists. creating PS Object DAL primitives UDFs of dal.sql creating WIT Object full text UDFs of dal.sql creating sprocs of dal.sql Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.GetAccountDisplayMode'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists. Caution: Changing any part of an object name could break scripts and stored procedures.Caution: Changing any part of an object name could break scripts and stored procedures.Caution: Changing any part of an object name could break scripts and stored procedures.Caution: Changing any part of an object name could break scripts and stored procedures.Caution: Changing any part of an object name could break scripts and stored procedures. End of inthebox.sql filecreating PS Object DAL primitives sprocs of dal.sql Creating Procedure ClearInstanceInfo Creating Procedure GetInstanceInfo Creating Procedure SetInstanceInfo creating UDFs of dal.sql creating UDFs of dal.sql Creating Procedure prc_EnableDBUser Stamping DB...********************************************************************* PLEASE IGNORE ALL SYSDEPENDS AND KEY MAX LENGTH WARNINGS ********************************************************************Completed deployment of data tier TfsWorkItemTrackingCopying the schema version to 9.20904.00 on TfsWorkItemTracking Stamping the product version to 9.0.21022.8 on TfsWorkItemTracking Adding the account DoneCreating the Work Item Tracking Attachments Database Creating the Work Item Tracking Attachments Database (TfsWorkItemTrackingAttachments) attachments.tsq Creating the data deployer Creating the database Changed database context to 'master'. Running the script Halting condition evaluation for the remainder of the script. Stamping the product to_version 9.0.21022.8 on TfsWorkItemTrackingAttachments Creating Procedure prc_EnableDBUser Copying the schema version to 9.20904.00 on TfsWorkItemTrackingAttachments Stamping the product version to 9.0.21022.8 on TfsWorkItemTrackingAttachments Adding the account DoneCreating the Reporting Database Creating the Reporting Database (TfsWarehouse) D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe -setup -install -n -s HOUMSQL330 -d TfsWarehouse -c D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml -a HALHOUSTON\sv00033 -ra HALHOUSTON\sv00033 -asinst HOUMSQL330 -asdbname TfsWarehouse -asacct  D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe -setup -install -n -s HOUMSQL330 -d TfsWarehouse -c D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml -a HALHOUSTON\sv00033 -ra HALHOUSTON\sv00033 -asinst HOUMSQL330 -asdbname TfsWarehouse -asacct  An unexpected error occurred when connecting to the Analysis Server. Check that your Analysis Server is up and you have sufficient privileges on it: File system error: The following error occurred during a file operation:  Access is denied. . 4 D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 4 40673 Microsoft.TeamFoundation.DatabaseInstaller.DatabaseException: D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 4 40673   at Microsoft.TeamFoundation.DatabaseInstaller.ProcessDeployer.ExecuteCommand(String filePath, String arguments, Boolean continueOnError)Microsoft.TeamFoundation.DatabaseInstaller.DatabaseException: D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 4 40673   at Microsoft.TeamFoundation.DatabaseInstaller.ProcessDeployer.ExecuteCommand(String filePath, String arguments, Boolean continueOnError)   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.RunDbActions(InstallerMode mode, String server, Boolean preview)   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.RunSteps(InstallerMode mode, String server, IPropertyCollection properties, Boolean preview)   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.Install(String server, IPropertyCollection properties, Boolean preview)   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.Commands.CommandInstall.OnRun()   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.Commands.InstallerCommand.Run()   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.CommandLine.RunCommand(String args)
    D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe 4 4067311/28/07 11:42:50 DDSet_Status: Process returned 10011/28/07 11:42:51 DDSet_Status: Using default error code for return value '100' and it is: '29000'11/28/07 11:42:51 DDSet_Error:  100
     

    DB:3.36:Error 29000: Urgent - Help sa

    Since the error is:
     
    An unexpected error occurred when connecting to the Analysis Server. Check that your Analysis Server is up and you have sufficient privileges on it: File system error: The following error occurred during a file operation:  Access is denied. .
     
    You may also want to check:
    - analysis service is running as an account with sufficient privs (Local System would be easiest to ensure that)
    - the account you're running setup as has sufficient permissions on the analysis services server
      - easiest way would be to add it to the local Administrators group on the AS machine, generally the data tier machine.  Not fully necessary, but an easy way of making sure it's not a permissions issue.
     
    You should also check the error log on the analysis machine around the time of the failed setupwarehouse.exe run to see what errors it logged.

  • RELEVANCY SCORE 3.34

    DB:3.34:Transaction Type Does Not Exist x1



    While creating PR PO for the Assets I am getting Following Error

    Transaction type does not exist

    Message no. AA_BAS_CUS_READ008

    Diagnosis

    The transaction type entered does not exist.

    System Response

    Processing is terminated.

    Procedure

    Check your entry.

    Can any body please help me to make PR PO.

    Amit

  • RELEVANCY SCORE 3.34

    DB:3.34:Internal Error Ora-600 c3


    Hi,
    I am getting the internal error Ora-600 while creating the procedure. Actually i doing the schema level import and around 50% of the procedures are created and the rest is throwing the Ora-600 error. When i am trying in sqlplus window then also the same error message is displaying . My activity is get strucked with this.

    The error message is
    SQLPLUScreate procedure nscw.skproc as
    2 begin
    3 dbms_output.put_line('Welcome');
    4 end;
    5 /
    create procedure nscw.skproc as
    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [16221], [], [], [], [], [], [], []

    Pls help me immediately.

    Regards
    Gnanavel.

    DB:3.34:Internal Error Ora-600 c3

    Ora-600 very often means a bug. What version are you on?
    Try this:
    create procedure skproc as ...
    instead of
    create procedure nscw.skproc as ...

  • RELEVANCY SCORE 3.34

    DB:3.34:Error Message Appears With The Package Name Hr_Person_Absence Procedure Create_Person_Absence s3


    Hi Friends,I have put some validations while the employee is creating absences. The validation works fine. But when the error message is being shown I see the package name and procedure name at the top of the page. Any ideas how this can be removed. Thanks

    DB:3.34:Error Message Appears With The Package Name Hr_Person_Absence Procedure Create_Person_Absence s3

    Can't help without the complete error or code..You will have to speak to your DBAs

  • RELEVANCY SCORE 3.33

    DB:3.33:"Company Code Not Assigned To Country Or Country To Calculation Procedure" 9s



    Hi ,

    I'm practicing SAP on IDES at home.

    I have not created any 'Calculation procedure' (TAXINN or TAXINJ) neither assigned any procedure to

    country 'IN'. I have maintained tax category 'MWST' for 'IN' in OVK1 and also assigned my delivering plant

    for tax determination. I have also maintained tax relevancy for master records ( OVK3 - customer OVK4 -

    material ) and also maintained condition records for MWST.

    Everything is working fine while creating normal sales order including accounting document creation

    posting. But when I'm creating a purchase order ( ME21N) for 3rd party process getting the error "Company

    code not assigned to country or country to calculation procedure".

    Plz help me with the solution how to create calculation procedure or which procedure should I assign to country 'IN' from the list of available procedure.

    ( I can't take help from FI guy as I'm practicing on my own )

    DB:3.33:"Company Code Not Assigned To Country Or Country To Calculation Procedure" 9s


    Thanks everybody for their replies but still my query remains the same.

    I knw the error that i have not created any calculation procedure neither assigned it.

    But my que is how to create a new cal. procedure. If I create a new procedure which cond.type access seq. shall I select ? Shall I copy any proc. assigned it country 'IN' ?

    Solution awaited..

  • RELEVANCY SCORE 3.33

    DB:3.33:New Routine fx



    Hi friends,

    I had created one new routine( formula) and attached it to condition type in pricing procedure.

    Now while creating order it is giving the following error,

    bError while transferring conditions: duplicates found./b

    helpful replies will be rewarded.

    regards,

    vandana

  • RELEVANCY SCORE 3.33

    DB:3.33:Customer Not Determine In Sales Order 7p


    Hi all,While i'm creating sales order,i'm getting error like "no customer exit for sold to party 7000000" . Please sort out my problem as soon as possible. I have checked entire partner determination procedure. There all setting is fine.Thanks regardskeshav

    DB:3.33:Customer Not Determine In Sales Order 7p

    Dear Friend, Please Mark ur question status as answered before closing otherwise it waste other times.RegardsAJIT K SINGHHAPPY TO HELP U

  • RELEVANCY SCORE 3.32

    DB:3.32:Problem While Creating A Po In Sourcing.. 7m



    Dear SRM Gurus,

    We have implemented BBP_DOC_CHECK_BADI for checking the PO and we are triggering some error messages when some conditions of PO are not satisfied..

    BADI is working fine and the error messages are triggered and displayed..still when we press Create Purchase Order button, it is creating a PO with incomplete status..

    Please suggest if there any procedure to restrict the PO creation..

    Thanks and Regards,

    Chandra Sekhar.

    DB:3.32:Problem While Creating A Po In Sourcing.. 7m


    Hi Disha,

    We are using Extended Classic Scenario and we have implemented the BADI for PO in SRM only..

    Is there any way to restrict from creating PO..

    Thanks in adavance,

    Chandra Sekhar.

  • RELEVANCY SCORE 3.32

    DB:3.32:Procedure sp


    Hi

    What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS ...Can any one tell the answer with ur simple program....

    Regards,
    Sankar.C

    DB:3.32:Procedure sp

    till now
    i m writing is when its a funciton
    and as when its procedure

  • RELEVANCY SCORE 3.29

    DB:3.29:Cin Query zp



    HI,

    I have created a tax code in TAXINN procedure and enered the same while creating a purchase order.The system calculated the taxes as per the condition types given correctly.

    Then i did MIGO and lastly MIRO. But while doing MIRO the system was showing the error TAX CODE NOT CREATED IN TAXINN PROCEDURE.

    Please do the needful.

    DB:3.29:Cin Query zp


    dear,

    go to FTXP

    put tax code and maintain 0.000 value in any one condition then try to do MIRO

    it works,

    regards,

    snb

  • RELEVANCY SCORE 3.29

    DB:3.29:Asset Purchase Issue az



    Dear Sapguys,

    while creating of asset purchase i am getting below error message

    You cannot post to asset in company code 1010 fiscal year 2010

    Message no. AA347

    Diagnosis

    A fiscal year change has not yet been performed in Asset Accounting for company code 1010.

    Procedure

    Check the asset value date.

    Please guide me immediatly

    Regards

    Supreme

    DB:3.29:Asset Purchase Issue az


    Hi,

    Search before posting questions on the forum, since this question has been answered more than 1000 times here.

    To post transacitons in new FY, you need to open the new FY in AJRW for your company code.

    Thanks,

    Srinu

  • RELEVANCY SCORE 3.29

    DB:3.29:Error Message While Creating Stored Procedure fs


     
    I'm creating a simple stored procedure:
     

    create procedure spzipcode
    (
    @TableName nvarchar(10)
    )
    as
    select distinct customer_codefrom @TableName
    GO
     
    When running the code above, I get the following error message:
     

    Server: Msg 137, Level 15, State 2, Procedure spzipcode, Line 8Must declare the variable '@TableName'.
     
    I can't figure out what I'm doing wrong.
     
    Does anyone have an answer:
     
     

    DB:3.29:Error Message While Creating Stored Procedure fs

    Sorry, I just realized that you were referring to the revised code, not to my original post. This is meant to be run from an application, where the user would select the table name and the name would be passed to the stored procedure. To be safe, we'll create separate stored procedures with the table name hard coded, and run the appropriate SP depending on the table name.
     
    Thank you for all your help.

  • RELEVANCY SCORE 3.28

    DB:3.28:Error While Creating A Callable Object - User Interface jd



    Hello,

    When i'm trying to create a callable object - User Interface in the guided procedure design time. i'm getting an error. An internal server error. This is happening while i'm trying to create a guided procedure with webdynpro's.

    Is there any body who allready had somthing like this.

    Greetings

    Kurt

    DB:3.28:Error While Creating A Callable Object - User Interface jd


    Hi,

    Please check if all the DC dependencies are properly created. Use Weak as runtime qualifire. Also, if caf/eu/gp/api is added as library reference.

    Regards,

    Aditya.

  • RELEVANCY SCORE 3.28

    DB:3.28:Co.Code Not Defined To Country Or Country To The Calculation Procedure Erro 71



    Hai All,

    Iam facing an error while creating the PO i.e., co.code not assigned to country or country to the calculation procedure error.

    Actually, Iam working in 800 client and there is no TAXINN so how is it possible to assign the country India to the calculation procedure?

    Please help me out.

    Regards

    ANU

    DB:3.28:Co.Code Not Defined To Country Or Country To The Calculation Procedure Erro 71


    Hi Friend,

    I think you are working with SAP 4.7EE version. In 4.7EE version TAXINN procedure not created in 800 Client. If you have authorization to view 000 Client, You can find TAXINN procedure in 000 Client.

    For your problem, I will suggest 2 solutions:

    Ist solution: Open simultaneously 000 and 800 clients in your system (4.7EE), then you can replicate the TAXINN procedure in 800 client.

    Second solution: You can use any other available/existing Tax procedure in your client to resolve your said problem.

    If you are using 4.6C version, you have to install CIN add-on.

    From ECC6.0 Version you can find TAXINN procedure in 800 client also. Please let me know if you have any clarifications.

    Thanks

    Chandra

  • RELEVANCY SCORE 3.28

    DB:3.28:Error While Creating Partner Determination Procedure xf



    hi, i am geeting error while assigning partner roles to partner determination procedure for vendor master.

    The error is u can not use this role here. and the error description is " the partner roles u can use in vendor master ,purchasing arrangement area is LI,PE,OP."

    i have created my partner roles with LI type by copying the existing LI type.

    can u please suggest me where i did wrong?

    thanks in advance

    srini

    DB:3.28:Error While Creating Partner Determination Procedure xf


    Have you checked your config settings.

    Search for "Permissible Partner Roles per Account Group" in SPRO

    Make sure the vendor account that you are creating is using an account group that has your new partner in it.

  • RELEVANCY SCORE 3.24

    DB:3.24:Lsmw Error 17



    Hi,

    I ve got an error while doing LSMW as follows:

    BDC_INSERT, Transaction code .. is invalid

    Message no. 00338

    Diagnosis

    Error creating a batch input session.

    Procedure

    Contact the person in charge.

    What should I do?

    DB:3.24:Lsmw Error 17


    who has created the LSMW object?

    what import mehtod (step 1) is used?

    Please insert the most important part of this message: Transaction code .. is invalid

    what is actually listed where you added the .. ?

  • RELEVANCY SCORE 3.24

    DB:3.24:Condition Zof2 Is Missing In Pricing Procedure A M Local jz



    Hi,

    While creating a PO, appearing an error message Condition ZOF2 is missing in pricing procedure A M LOCAL..

    Where i have to configure it??

    Plz guide..

    DB:3.24:Condition Zof2 Is Missing In Pricing Procedure A M Local jz


    Hi,

    While creating a PO, appearing an error message Condition ZOF2 is missing in pricing procedure A M LOCAL..

    Where i have to configure it??

    Plz guide..

  • RELEVANCY SCORE 3.24

    DB:3.24:Foreach Loop Erro While Creating Procedure? 89


    hello all, i am creating a proceudre with foreach loop, created with compilation error. please correct me if some mistake is there...

    CREATE PROCEDURE update_list as
    DEFINE name VARCHAR(30);
    DEFINE address VARCHAR(255);
    begin
    FOREACH namedCursor FOR
    SELECT ename, eaddress INTO name, address FROM emp
    INSERT INTO mailing_list VALUES(name, address);
    IF(ename="McAllister") THEN
    UPDATE emp SET sal = sal + 2000 WHERE CURRENT OF namedCursor;
    CONTINUE FOREACH;
    END IF;
    UPDATE emp SET sal = sal + 1000 WHERE CURRENT OF namedCursor;
    END FOREACH;
    END PROCEDURE;

    thanks
    yash

    mailing_list table is created with field.

    DB:3.24:Foreach Loop Erro While Creating Procedure? 89

    First it would be nice if you posted which error you get rather than just "compilation error". If you are using SQL*PLUS, try "show error" after you get "compiled with errors". It will tell you details of the error.

    Second I do not know what language this is? DEFINE is not a PL/SQL word and neither is FOREACH as far as I know :-) ? Is this Microsoft SQL Server T-SQL or what?

    Consider reading the [url http://download.oracle.com/docs/cd/E11882_01/appdev.112/e17126/toc.htm]PL/SQL Language Reference - it contains lots of nice examples.

  • RELEVANCY SCORE 3.23

    DB:3.23:Installation Issues With Tfs 2010 Beta 2 mj


    I'm having issues getting TFS 2010 Beta 2 to install, we had it installed on our dev boxand then I had to uninstall to upgrade VS2010 RC1, when I try to reinstall I keep getting a failed install below is the install log[Info @15:06:29.143] SQL Info: Creating Procedure prc_iiRenameTokens[Info @15:06:29.197] SQL Info: Creating Procedure prc_iiRemoveAccessControlList[Info @15:06:29.215] SQL Info: Creating Procedure prc_iiSetAccessControlLists[Info @15:06:29.254] SQL Info: Creating Procedure prc_pRemoveAccessControlEntry[Info @15:06:29.276] SQL Info: The module 'prc_pRemoveAccessControlEntry' depends on the missing object 'prc_pRemoveAccessControlEntries'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:29.326] SQL Info: Creating Procedure prc_pRemoveAccessControlEntries[Info @15:06:29.345] SQL Info: Creating Procedure prc_pRenameToken[Info @15:06:29.352] SQL Info: The module 'prc_pRenameToken' depends on the missing object 'prc_pRenameTokens'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:29.361] SQL Info: Creating Procedure prc_pRenameTokens[Info @15:06:29.377] SQL Info: Creating Procedure prc_pSetAccessControlEntry[Info @15:06:29.400] SQL Info: The module 'prc_pSetAccessControlEntry' depends on the missing object 'prc_pSetAccessControlLists'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:29.418] SQL Info: Creating Procedure prc_pSetAccessControlLists[Info @15:06:29.433] SQL Info: Creating Procedure prc_QueryIdentitiesWithACEs[Info @15:06:29.445] SQL Info: Creating Procedure prc_QuerySecurityInfo[Info @15:06:29.466] SQL Info: Creating Procedure prc_RemoveAccessControlEntry[Info @15:06:29.486] SQL Info: Creating Procedure prc_RemoveAccessControlList[Info @15:06:29.506] SQL Info: Creating Procedure prc_RemoveAllAccessControlLists[Info @15:06:29.526] SQL Info: Creating Procedure prc_SetAccessControlLists[Info @15:06:29.542] SQL Info: Creating Procedure prc_SetInheritFlag[Info @15:06:29.563] SQL Info: Creating Procedure prc_RenameToken[Info @15:06:29.583] SQL Info: Creating Procedure prc_QueryNotifications[Info @15:06:29.593] SQL Info: The module 'prc_QueryNotifications' depends on the missing object 'prc_iRenewLease'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:29.603] SQL Info: Creating Procedure prc_QueryNotificationWatermark[Info @15:06:29.622] SQL Info: Creating Procedure prc_SendNotification[Info @15:06:29.686] SQL Info: Creating Procedure prc_CreateCommand[Info @15:06:29.703] SQL Info: Creating Procedure prc_LogActivity[Info @15:06:29.734] SQL Info: Creating Procedure prc_PruneCommands[Info @15:06:29.754] SQL Info: Creating Procedure prc_QueryRegistryAuditLog[Info @15:06:29.774] SQL Info: Creating Procedure prc_QueryRegistry[Info @15:06:29.790] SQL Info: Creating Procedure prc_UpdateRegistry[Info @15:06:29.858] SQL Info: Creating Procedure prc_iiLogLocationChange[Info @15:06:29.882] SQL Info: Creating Procedure prc_iiConfigureAccessMapping[Info @15:06:29.906] SQL Info: Creating Procedure prc_iiSetDefaultAccessMapping[Info @15:06:29.963] SQL Info: Creating Procedure prc_iiUpdateLocationMappings[Info @15:06:30.000] SQL Info: Creating Procedure prc_iQueryServiceData[Info @15:06:30.019] SQL Info: Creating Procedure prc_ConfigureAccessMapping[Info @15:06:30.035] SQL Info: Creating Procedure prc_RemoveAccessMappings[Info @15:06:30.055] SQL Info: Creating Procedure prc_QueryServiceData[Info @15:06:30.071] SQL Info: Creating Procedure prc_SaveServiceDefinitions[Info @15:06:30.104] SQL Info: Creating Procedure prc_SetDefaultAccessMapping[Info @15:06:30.119] SQL Info: Creating Procedure prc_RemoveServiceDefinitions[Info @15:06:30.151] SQL Info: Creating Procedure prc_QuerySecurityNamespaces[Info @15:06:30.175] SQL Info: Creating Procedure prc_CreateSecurityNamespace[Info @15:06:30.227] SQL Info: Creating Procedure prc_DeleteSecurityNamespace[Info @15:06:30.255] SQL Info: Creating Procedure prc_UpdateSecurityNamespace[Info @15:06:30.280] SQL Info: Creating Procedure prc_AddEventTypes[Info @15:06:30.312] SQL Info: Creating Procedure prc_FireEvents[Info @15:06:30.337] SQL Info: Creating Procedure prc_GetEventTypes[Info @15:06:30.364] SQL Info: Creating Procedure prc_GetUnprocessedEvents[Info @15:06:30.384] SQL Info: Creating Procedure prc_GetUnprocessedNotifications[Info @15:06:30.409] SQL Info: Creating Procedure prc_QuerySubscriptions[Info @15:06:30.440] SQL Info: Creating Procedure prc_SaveProcessedEvents[Info @15:06:30.477] SQL Info: Creating Procedure prc_SaveProcessedNotifications[Info @15:06:30.517] SQL Info: Creating Procedure prc_SubscribeEvent[Info @15:06:30.536] SQL Info: Creating Procedure prc_UnsubscribeEvent[Info @15:06:30.568] SQL Info: Creating Procedure prc_AcquireLock[Info @15:06:30.584] SQL Info: Creating Procedure prc_QueryLockMode[Info @15:06:30.599] SQL Info: Creating Procedure prc_ReleaseLock[Info @15:06:30.615] SQL Info: Creating Procedure prc_QueryJob[Info @15:06:30.632] SQL Info: Creating Procedure prc_QueryJobs[Info @15:06:30.668] SQL Info: Creating Procedure prc_UpdateJobs[Info @15:06:30.704] SQL Info: Creating Procedure prc_UpdateLastExecutionTime[Info @15:06:30.720] SQL Info: Creating Procedure prc_AddServicingStepGroupHistory[Info @15:06:30.736] SQL Info: Creating Procedure prc_QueryServicingStepGroupPassed[Info @15:06:30.753] SQL Info: Creating Procedure prc_DeleteServicingStepGroupHistory[Info @15:06:30.784] SQL Info: Creating Procedure prc_PurgeData[Info @15:06:30.812] SQL Info: Creating Procedure prc_DeleteArtifactKind[Info @15:06:30.839] SQL Info: Creating Procedure prc_GetPropertyKinds[Info @15:06:30.853] SQL Info: Creating Procedure prc_CreateArtifactKind[Info @15:06:31.251] Process finished: fileName=C:\Program Files\Microsoft Team Foundation Server 2010\Tools\tfsconfig.exe arguments=perfCounters /load /type:applicationTier exitCode=0 in 4713 ms[Info @15:06:31.251] Logging sent to file C:\ProgramData\Microsoft\Team Foundation\Server Configuration\Logs\CFG_DPLY_AT_0219_150629.log[Info @15:06:31.251] Command: perfCounters[Info @15:06:31.251] Visual Studio Team System 2010 Team Foundation Server Beta 2 Configuration Tool[Info @15:06:31.251] Copyright (c) Microsoft Corporation. All rights reserved.[Info @15:06:31.251] Installing application tier performance counters.[Info @15:06:31.868] SQL Info: Creating Procedure prc_AddServicingStepDetail[Info @15:06:31.886] SQL Info: Creating Procedure prc_AddUpdatePackageHistoryEntry[Info @15:06:31.899] SQL Info: Creating Procedure prc_DeleteServicingFiles[Info @15:06:31.917] SQL Info: Creating Procedure prc_DeleteServicingOperation[Info @15:06:31.925] SQL Info: Creating Procedure prc_DeleteServicingStepGroups[Info @15:06:31.941] SQL Info: Creating Procedure prc_GetServicingOperation[Info @15:06:31.963] SQL Info: Creating Procedure prc_iiUploadServicingFile[Info @15:06:31.974] SQL Info: Creating Procedure prc_UpdateServicingJobDetail[Info @15:06:31.986] SQL Info: Creating Procedure prc_UpdateServicingStepGroups[Info @15:06:32.026] SQL Info: Creating Procedure prc_UpdateServicingOperation[Info @15:06:32.050] SQL Info: Creating Procedure prc_UploadReleaseManifest[Info @15:06:32.088] SQL Info: Creating Procedure prc_UploadServicingFile[Info @15:06:32.108] SQL Info: Creating Procedure prc_QueryServicingFileContents[Info @15:06:32.131] SQL Info: Creating Procedure prc_QueryServicingFiles[Info @15:06:32.148] SQL Info: Creating Procedure prc_QueryServicingStepDetails[Info @15:06:32.163] SQL Info: Creating Procedure prc_QueryServicingStepGroupOperations[Info @15:06:32.216] SQL Info: Creating Procedure prc_iRenewLease[Info @15:06:32.223] SQL Info: The module 'prc_iRenewLease' depends on the missing object 'prc_DetectInactiveProcesses'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:32.241] SQL Info: Creating Procedure prc_CreateServiceHost[Info @15:06:32.322] SQL Info: Creating Procedure prc_PauseServiceHost[Info @15:06:32.337] SQL Info: The module 'prc_PauseServiceHost' depends on the missing object 'prc_DetectInactiveProcesses'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:32.350] SQL Info: Creating Procedure prc_QueryPingResponse[Info @15:06:32.365] SQL Info: Creating Procedure prc_QueryServiceHostProperties[Info @15:06:32.390] SQL Info: Creating Procedure prc_QueryServiceHostPropertiesExtended[Info @15:06:32.430] SQL Info: Creating Procedure prc_RegisterServiceHostInstance[Info @15:06:32.482] SQL Info: Creating Procedure prc_DeleteServiceHost[Info @15:06:32.510] SQL Info: Creating Procedure prc_StartServiceHost[Info @15:06:32.526] SQL Info: The module 'prc_StartServiceHost' depends on the missing object 'prc_DetectInactiveProcesses'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:32.546] SQL Info: Creating Procedure prc_StopServiceHost[Info @15:06:32.578] SQL Info: The module 'prc_StopServiceHost' depends on the missing object 'prc_DetectInactiveProcesses'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:32.587] SQL Info: Creating Procedure prc_UnregisterServiceHostInstance[Info @15:06:32.631] SQL Info: Creating Procedure prc_UpdateMachineId[Info @15:06:32.646] SQL Info: Creating Procedure prc_UpdateServiceHost[Info @15:06:32.667] SQL Info: Creating Procedure prc_UpdateServiceHostInstance[Info @15:06:32.691] SQL Info: Creating Procedure prc_UpdateServiceHostLastUserAccess[Info @15:06:32.743] SQL Info: Creating Procedure prc_WritePingRequest[Info @15:06:32.761] SQL Info: Creating Procedure prc_WritePingResponse[Info @15:06:32.777] SQL Info: Creating Procedure prc_iiReleaseJob[Info @15:06:32.800] SQL Info: Creating Procedure prc_ReleaseJob[Info @15:06:32.827] SQL Info: Creating Procedure prc_ChangeJobState[Info @15:06:32.859] SQL Info: Creating Procedure prc_CleanupJobHistory[Info @15:06:32.883] SQL Info: Creating Procedure prc_PauseJob[Info @15:06:32.907] SQL Info: Creating Procedure prc_QueryJobHistory[Info @15:06:32.935] SQL Info: Creating Procedure prc_QueryLatestJobHistory[Info @15:06:32.963] SQL Info: Creating Procedure prc_QueryJobQueue[Info @15:06:32.995] SQL Info: Creating Procedure prc_QueryQueuedJobs[Info @15:06:33.015] SQL Info: Creating Procedure prc_QueryJobQueueForOneHost[Info @15:06:33.051] SQL Info: Creating Procedure prc_QueueJobsNow[Info @15:06:33.079] SQL Info: Creating Procedure prc_RescheduleJobs[Info @15:06:33.090] SQL Info: Creating Procedure prc_ResumeJob[Info @15:06:33.106] SQL Info: Creating Procedure prc_AcquireJob[Info @15:06:33.122] SQL Info: Creating Procedure prc_StopJob[Info @15:06:33.138] SQL Info: Creating Procedure prc_UpdateJobQueue[Info @15:06:33.167] SQL Info: Creating Procedure prc_SetJobQueueForOneHost[Info @15:06:33.207] SQL Info: Creating Procedure prc_iQueryCatalogObjects[Info @15:06:33.230] SQL Info: Creating Procedure prc_QueryCatalogDependents[Info @15:06:33.280] SQL Info: Creating Procedure prc_QueryCatalogNodes[Info @15:06:33.308] SQL Info: Creating Procedure prc_QueryCatalogResourceTypes[Info @15:06:33.336] SQL Info: Creating Procedure prc_QueryCatalogResources[Info @15:06:33.372] SQL Info: Creating Procedure prc_QueryCatalogResourcesByType[Info @15:06:33.493] SQL Info: Creating Procedure prc_QueryCatalogParents[Info @15:06:33.520] SQL Info: Creating Procedure prc_SaveCatalogResourceTypes[Info @15:06:33.548] SQL Info: Creating Procedure prc_SaveCatalogChanges[Info @15:06:33.861] SQL Info: Warning! The maximum key length is 900 bytes. The index 'ix_security_identity_cache_type_domain_display' has maximum length of 1035 bytes. For some combination of large values, the insert/update operation will fail.[Info @15:06:33.910] SQL Info: Warning! The maximum key length is 900 bytes. The index 'ix_security_identity_cache_display' has maximum length of 1030 bytes. For some combination of large values, the insert/update operation will fail.[Info @15:06:33.934] SQL Info: Warning! The maximum key length is 900 bytes. The index 'ix_security_identity_cache_disambiguation' has maximum length of 1024 bytes. For some combination of large values, the insert/update operation will fail.[Info @15:06:34.859] SQL Info: Creating Procedure prc_ii_gss_create_group[Info @15:06:34.883] SQL Info: Creating Procedure prc_ii_gss_create_user[Info @15:06:34.895] SQL Info: Creating Procedure prc_ii_gss_create_scope[Info @15:06:34.907] SQL Info: The module 'prc_ii_gss_create_scope' depends on the missing object 'prc_ii_gss_add_group_member'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:34.912] SQL Info: Creating Procedure prc_ii_gss_delete_scope[Info @15:06:34.927] SQL Info: The module 'prc_ii_gss_delete_scope' depends on the missing object 'dbo.prc_ii_security_delete_identities'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:34.940] SQL Info: Creating Procedure prc_ii_gss_rename_scope[Info @15:06:34.960] SQL Info: Creating Procedure prc_ii_gss_add_group_member[Info @15:06:34.981] SQL Info: The module 'prc_ii_gss_add_group_member' depends on the missing object 'prc_ii_security_process_deleted_accounts'. The module will still be created; however, it cannot run successfully until the object exists.The module 'prc_ii_gss_add_group_member' depends on the missing object 'prc_ii_security_delete_identities'. The module will still be created; however, it cannot run successfully until the object exists.The module 'prc_ii_gss_add_group_member' depends on the missing object 'prc_ii_security_ensure_unique_users'. The module will still be created; however, it cannot run successfully until the object exists.The module 'prc_ii_gss_add_group_member' depends on the missing object 'prc_ii_security_disambiguate'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:34.987] SQL Info: Creating Procedure prc_ii_security_delete_identities[Info @15:06:35.010] SQL Info: Creating Procedure prc_ii_security_disambiguate[Info @15:06:35.051] SQL Info: Creating Procedure prc_ii_security_ensure_unique_users[Info @15:06:35.062] SQL Info: Warning! The maximum key length is 900 bytes. The index 'PK__#52AE427__DC875DFD54968AE5' has maximum length of 1024 bytes. For some combination of large values, the insert/update operation will fail.[Info @15:06:35.067] SQL Info: Creating Procedure prc_ii_security_process_deleted_accounts[Info @15:06:35.086] SQL Info: Creating Procedure prc_ii_security_remove_group_member[Info @15:06:35.235] SQL Info: Creating Procedure prc_gss_add_group_member[Info @15:06:35.254] SQL Info: Creating Procedure prc_gss_create_scope[Info @15:06:35.271] SQL Info: Creating Procedure prc_gss_rename_scope[Info @15:06:35.286] SQL Info: Creating Procedure prc_gss_get_scope_id[Info @15:06:35.307] SQL Info: Creating Procedure prc_gss_get_scope_name[Info @15:06:35.322] SQL Info: Creating Procedure prc_gss_create_identity[Info @15:06:35.339] SQL Info: Creating Procedure prc_gss_delete_scope[Info @15:06:35.355] SQL Info: Creating Procedure prc_gss_find_group_by_sid[Info @15:06:35.383] SQL Info: Creating Procedure prc_gss_find_group_by_display_name[Info @15:06:35.473] SQL Info: Creating Procedure prc_gss_find_groups_by_special_type[Info @15:06:35.493] SQL Info: Creating Procedure prc_gss_install[Info @15:06:35.517] SQL Info: Creating Procedure prc_gss_remove_group[Info @15:06:35.566] SQL Info: Creating Procedure prc_gss_remove_group_member[Info @15:06:35.610] SQL Info: Creating Procedure prc_gss_update_group[Info @15:06:35.643] SQL Info: Creating Procedure prc_security_add_for_update_identity[Info @15:06:35.666] SQL Info: Creating Procedure prc_security_add_inactive_identities[Info @15:06:35.690] SQL Info: Creating Procedure prc_security_add_to_sync_queue[Info @15:06:35.706] SQL Info: Creating Procedure prc_security_add_sync_exclusion[Info @15:06:35.722] SQL Info: Creating Procedure prc_security_change_domain_sid[Info @15:06:35.738] SQL Info: Creating Procedure prc_security_clear_sync_exclusion[Info @15:06:35.787] SQL Info: Creating Procedure prc_security_read_sync_exclusion[Info @15:06:35.831] SQL Info: Creating Procedure prc_security_assign_sequence_id[Info @15:06:35.847] SQL Info: Creating Procedure prc_security_delete_identity[Info @15:06:35.898] SQL Info: Creating Procedure prc_security_find_groups_to_sync[Info @15:06:35.918] SQL Info: Creating Procedure prc_security_find_groups[Info @15:06:35.958] SQL Info: Creating Procedure prc_security_get_changed_identities[Info @15:06:35.987] SQL Info: The module 'prc_security_get_changed_identities' depends on the missing object 'prc_security_get_changed_identities_full'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:35.995] SQL Info: Creating Procedure prc_security_get_changed_identities_full[Info @15:06:36.011] SQL Info: Creating Procedure prc_security_list_groups[Info @15:06:36.030] SQL Info: Creating Procedure prc_NotifyIdentityChanged[Info @15:06:36.047] SQL Info: Creating Procedure prc_security_prepare_update_identity[Info @15:06:36.063] SQL Info: Creating Procedure prc_security_query_identities[Info @15:06:36.079] SQL Info: Creating Procedure prc_security_query_by_display_name[Info @15:06:36.095] SQL Info: Creating Procedure prc_security_read_identity[Info @15:06:36.106] SQL Info: The module 'prc_security_read_identity' depends on the missing object 'prc_security_read_membership'. The module will still be created; however, it cannot run successfully until the object exists.[Info @15:06:36.128] SQL Info: Creating Procedure prc_security_read_membership[Info @15:06:36.167] SQL Info: Creating Procedure prc_security_read_identities[Info @15:06:36.188] SQL Info: Creating Procedure prc_security_read_identity_by_tf_id[Info @15:06:36.216] SQL Info: Creating Procedure prc_security_read_identities_by_tf_id[Info @15:06:36.240] SQL Info: Creating Procedure prc_security_read_from_sync_queue[Info @15:06:36.255] SQL Info: Creating Procedure prc_security_read_parents[Info @15:06:36.273] SQL Info: Creating Procedure prc_security_read_root[Info @15:06:36.301] SQL Info: Creating Procedure prc_security_remove_from_sync_queue[Info @15:06:36.321] SQL Info: Creating Procedure prc_security_read_snapshot[Info @15:06:36.337] SQL Info: Creating Procedure prc_security_update_identity[Info @15:06:36.486] SQL Info: Creating Procedure prc_security_update_sid[Info @15:06:36.523] SQL Info: Creating Procedure prc_security_get_total_identities[Info @15:06:36.563] SQL Info: Creating Procedure prc_security_remove_for_update_identity[Info @15:06:36.587] SQL Info: Creating Procedure prc_gss_uninstall[Info @15:06:36.615] SQL Info: Creating Function fn_gss_sid_member_of_group[Info @15:06:36.657] SQL Info: Creating Procedure prc_DetectInactiveProcesses[Info @15:06:36.879] [2010-02-19 15:06:36Z] Servicing step Create Configuration Database passed. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.879] [2010-02-19 15:06:36Z] Executing servicing step Write configuration in progress stamp. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.879] Step Performer: Administration[Info @15:06:36.879] Step Type: WriteConfigurationInProgressStamp[Info @15:06:36.879] Step Data Text: [Info @15:06:36.890] Setting Extended Property: TFS_CONFIGURATION_IN_PROGRESS=Y [from DB Data Source=WSLAM\BI2010;Initial Catalog=Tfs_Configuration;Integrated Security=True][Info @15:06:36.891] [2010-02-19 15:06:36Z] Servicing step Write configuration in progress stamp passed. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.891] [2010-02-19 15:06:36Z] Executing servicing step Write servicing level to stamp. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.891] Step Performer: Administration[Info @15:06:36.891] Step Type: WriteConfigurationServiceLevelToStamp[Info @15:06:36.891] Step Data Text: [Info @15:06:36.902] Setting Extended Property: TFS_SERVICE_LEVEL_TO=Tfs2010.Beta2 [from DB Data Source=WSLAM\BI2010;Initial Catalog=Tfs_Configuration;Integrated Security=True][Info @15:06:36.902] [2010-02-19 15:06:36Z] Servicing step Write servicing level to stamp passed. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.903] [2010-02-19 15:06:36Z] Executing servicing step Update Schema Version. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.903] Step Performer: Framework[Info @15:06:36.903] Step Type: WriteSchemaVersion[Info @15:06:36.903] Step Data Text: [Info @15:06:36.910] [2010-02-19 15:06:36Z] Servicing step Update Schema Version passed. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.910] [2010-02-19 15:06:36Z] Executing servicing step Write database type information. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.910] Step Performer: Framework[Info @15:06:36.910] Step Type: WriteDatabaseAttribute[Info @15:06:36.911] Step Data Text: WriteDatabaseAttributeStepData attribute=TFS_DATABASE_TYPE value=Configuration category=Framework /[Info @15:06:36.911] Step Data: DatabaseCategory = Framework[Info @15:06:36.911] Step Data: DatabaseAttribute = TFS_DATABASE_TYPE[Info @15:06:36.911] Step Data: AttributeValue = Configuration[Info @15:06:36.914] [2010-02-19 15:06:36Z] Servicing step Write database type information passed. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.914] [2010-02-19 15:06:36Z] Executing servicing step Register Configuration Database. (ServicingOperation: Install; Step group: Install)[Info @15:06:36.915] Step Performer: Administration[Info @15:06:36.915] Step Type: RegisterApplication[Info @15:06:36.915] Step Data Text: RegisterApplicationStepData instanceStamp=af3abe2d7549431081a79a79368aaaa0 /[Info @15:06:36.915] Configuration TFS Instance af3abe2d7549431081a79a79368aaaa0[Info @15:06:36.915] TFS Database name locked as Tfs_Configuration[Info @15:06:36.915] Writing TFS_SCHEMA_VERSION as Team Foundation Server 2010 Beta2[Info @15:06:36.922] Creating the service host for instance af3abe2d-7549-4310-81a7-9a79368aaaa0[Info @15:06:36.934] Adding the service host to the target request context[Error @15:06:37.199] Object reference not set to an instance of an object.[Info @15:06:37.199] System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.TeamFoundation.Framework.Server.TeamFoundationRegistryService.WriteEntriesInternal(TeamFoundationRequestContext requestContext, IEnumerable`1 registryEntries, Boolean allowNulls) at Microsoft.TeamFoundation.Admin.Deploy.Application.AdminStepPerformer.RegisterApplication(String stepData, ServicingContext servicingContext, Boolean validateOnly) at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep(String servicingOperation, String stepType, String stepData, ServicingContext servicingContext) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly)[Info @15:06:37.199] [2010-02-19 15:06:37Z] Servicing step Register Configuration Database failed. (ServicingOperation: Install; Step group: Install)[Error @15:06:37.223] TF255184: An error occurred during operation. Message=TF255356: The following error occurred when configuring the Team Foundation databases: Error occurred while executing servicing step Register Configuration Database for component Install during Install: Object reference not set to an instance of an object.. For more information, see the configuration log..[Error @15:06:37.224] Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: Error occurred while executing servicing step Register Configuration Database for component Install during Install: Object reference not set to an instance of an object. --- System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.TeamFoundation.Framework.Server.TeamFoundationRegistryService.WriteEntriesInternal(TeamFoundationRequestContext requestContext, IEnumerable`1 registryEntries, Boolean allowNulls) at Microsoft.TeamFoundation.Admin.Deploy.Application.AdminStepPerformer.RegisterApplication(String stepData, ServicingContext servicingContext, Boolean validateOnly) at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep(String servicingOperation, String stepType, String stepData, ServicingContext servicingContext) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly) --- End of inner exception stack trace --- at Microsoft.TeamFoundation.Framework.Server.ServicingContext.FinishStep(Exception exception) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformOperations(Boolean validateOnly, Int32 stepsToPerform) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.Execute(Int32 numberOfStepsToPerform) at Microsoft.TeamFoundation.Admin.ApplicationDataTier.Apply(OperationContext context)[Verbose@15:06:37.224] Throw On Error = True[Error @15:06:37.224] TF255248: The process applying the configuration must be terminated due to an error.[Error @15:06:37.226] TF255247: An error occurred while applying the following configuration: Microsoft.TeamFoundation.Admin.ConfigurationApplyException: TF255356: The following error occurred when configuring the Team Foundation databases: Error occurred while executing servicing step Register Configuration Database for component Install during Install: Object reference not set to an instance of an object.. For more information, see the configuration log. (Error occurred while executing servicing step Register Configuration Database for component Install during Install: Object reference not set to an instance of an object.) --- Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: Error occurred while executing servicing step Register Configuration Database for component Install during Install: Object reference not set to an instance of an object. --- System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.TeamFoundation.Framework.Server.TeamFoundationRegistryService.WriteEntriesInternal(TeamFoundationRequestContext requestContext, IEnumerable`1 registryEntries, Boolean allowNulls) at Microsoft.TeamFoundation.Admin.Deploy.Application.AdminStepPerformer.RegisterApplication(String stepData, ServicingContext servicingContext, Boolean validateOnly) at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep(String servicingOperation, String stepType, String stepData, ServicingContext servicingContext) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly) --- End of inner exception stack trace --- at Microsoft.TeamFoundation.Framework.Server.ServicingContext.FinishStep(Exception exception) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformOperations(Boolean validateOnly, Int32 stepsToPerform) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.Execute(Int32 numberOfStepsToPerform) at Microsoft.TeamFoundation.Admin.ApplicationDataTier.Apply(OperationContext context) --- End of inner exception stack trace --- at Microsoft.TeamFoundation.Admin.ErrorList.HandleError(IResult result) at Microsoft.TeamFoundation.Admin.ErrorList.Add(IResult result) at Microsoft.TeamFoundation.Admin.ApplicationDataTier.Apply(OperationContext context) at Microsoft.TeamFoundation.Admin.ConfigurationNode.ApplyIfReady(OperationContext context) at Microsoft.TeamFoundation.Admin.ApplicationTier.Install(OperationContext context) at Microsoft.TeamFoundation.Admin.ConfigurationNode.ApplyIfReady(OperationContext context) at Microsoft.TeamFoundation.Admin.LogicalTier.Apply(OperationalMode mode).--------------------------------------------------------------------------Microsoft.TeamFoundation.Admin.ConfigurationApplyException: TF255356: The following error occurred when configuring the Team Foundation databases: Error occurred while executing servicing step Register Configuration Database for component Install during Install: Object reference not set to an instance of an object.. For more information, see the configuration log. (Error occurred while executing servicing step Register Configuration Database for component Install during Install: Object reference not set to an instance of an object.) --- Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: Error occurred while executing servicing step Register Configuration Database for component Install during Install: Object reference not set to an instance of an object. --- System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.TeamFoundation.Framework.Server.TeamFoundationRegistryService.WriteEntriesInternal(TeamFoundationRequestContext requestContext, IEnumerable`1 registryEntries, Boolean allowNulls) at Microsoft.TeamFoundation.Admin.Deploy.Application.AdminStepPerformer.RegisterApplication(String stepData, ServicingContext servicingContext, Boolean validateOnly) at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep(String servicingOperation, String stepType, String stepData, ServicingContext servicingContext) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly) --- End of inner exception stack trace --- at Microsoft.TeamFoundation.Framework.Server.ServicingContext.FinishStep(Exception exception) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformOperations(Boolean validateOnly, Int32 stepsToPerform) at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.Execute(Int32 numberOfStepsToPerform) at Microsoft.TeamFoundation.Admin.ApplicationDataTier.Apply(OperationContext context) --- End of inner exception stack trace --- at Microsoft.TeamFoundation.Admin.ErrorList.HandleError(IResult result) at Microsoft.TeamFoundation.Admin.ErrorList.Add(IResult result) at Microsoft.TeamFoundation.Admin.ApplicationDataTier.Apply(OperationContext context) at Microsoft.TeamFoundation.Admin.ConfigurationNode.ApplyIfReady(OperationContext context) at Microsoft.TeamFoundation.Admin.ApplicationTier.Install(OperationContext context) at Microsoft.TeamFoundation.Admin.ConfigurationNode.ApplyIfReady(OperationContext context) at Microsoft.TeamFoundation.Admin.LogicalTier.Apply(OperationalMode mode)**************************************************************************

    DB:3.23:Installation Issues With Tfs 2010 Beta 2 mj

    Hi,Is this issue fixed?Best regards,
    Ruiz

    MSDN Subscriber Support in Forum

    If you have any feedback on our support, please contact msdnmg @ microsoft.com

  • RELEVANCY SCORE 3.23

    DB:3.23:Transaction Does Not Exist js



    hi expert,

    While creating Asset PO i m getting following error;

    Transaction type does not exist

    Message no. AA_BAS_CUS_READ008

    Diagnosis

    The transaction type entered does not exist.

    System Response

    Processing is terminated.

    Procedure

    Check your entry.

    Please assist me to resolve error.

    Thanks in advance.

    DB:3.23:Transaction Does Not Exist js


    Check SAP Note 1257515 - AA_BAS_CUS_READ 008 for posting to fixed asset.

    Regards,

    EJ

  • RELEVANCY SCORE 3.23

    DB:3.23:Pricing Procedure Error In Sales Order c8



    Hi,

    I have made all necessary SD config. setting for pricing procedure creation and determination in Sales orders. But while creating a sales order I am getting an error as "No pricing procedure could be determined as entries are missing in TAble 683v. but I can see the relevant entry in this table. How this error can be rectified. i am unable to procees for sales order creation.

    DB:3.23:Pricing Procedure Error In Sales Order c8


    Hi All,

    one missing entry in the Customer master resolved the issue: Customer Pricing procedure assingnment in Sales tab of customer master.

    Thank you very much

    Regards

  • RELEVANCY SCORE 3.23

    DB:3.23:Error "Message Type "X" While Creating Transformation In Bi 7.0 37



    Hello Gurus,

    I am trying to upload data in to DSO from a flat file.

    As per procedure I created InfoObjects, Creted datasources. But wen I try creating transformation I m getting a short Dump Error "MESSAGE TYPE "X" .

    I created infopackage and I uploaded data into PSA without any problem.

    Now I want to create a transformation.

    Plz help me ...

    ..Chandru..

    DB:3.23:Error "Message Type "X" While Creating Transformation In Bi 7.0 37


    Hello Gurus,

    I am trying to upload data in to DSO from a flat file.

    As per procedure I created InfoObjects, Creted datasources. But wen I try creating transformation I m getting a short Dump Error "MESSAGE TYPE "X" .

    I created infopackage and I uploaded data into PSA without any problem.

    Now I want to create a transformation.

    Plz help me ...

    ..Chandru..

  • RELEVANCY SCORE 3.20

    DB:3.20:Company Code Not Assigned To Country Or Country To Calculation Procedure 7m



    Hi All !

    While creating PO the error "Company code not assigned to country or country to calculation procedure ' While creating the co code and company the warning message that ' no calculation procedure exist for country india ' had come but i ignored. now my inter company sales billing has gone fine but in intercompany stock transfer is giving this problem.

    Plz guide

    DB:3.20:Company Code Not Assigned To Country Or Country To Calculation Procedure 7m


    Hello,

    Agreed with Murali's comments. This error could be because the tax procedure is not maintined against the country. Please maintain the tax procedure against the country.

    SPRO -- Financial Accounting -- Financial Accounting Global Settings -- Tax on Sales/Purchases -- Basic Settings -- Assign Country to Calculation Procedure .

    Transaction OBBG.

    Prase

  • RELEVANCY SCORE 3.19

    DB:3.19:While Creating Invoice(Vf01) Getting Below Error Exc. Tax Ind. Not Maint. For 1 1 - Please Maintain sm



    Dear Experts,

    Please help our client has upgraded to ECC 6.0 using TAXINJ Procedure but while creating invoice(VF01) getting below error

    Exc. tax ind. not maint. for 1 1 - please maintain. In J1ID tax indicator is maintained.

    Kindly help

    Prashant

    DB:3.19:While Creating Invoice(Vf01) Getting Below Error Exc. Tax Ind. Not Maint. For 1 1 - Please Maintain sm


    Hi Prashant,

    Check the settings for excise indicator for plant, customer excise details for both the combinations maintain final excise indicator in excise indicator for plant and customer. As you are saying it is VF01, it might be missing for that this particular customer in J1ID.

    Regards,

    S.Himavanth.

  • RELEVANCY SCORE 3.19

    DB:3.19:Tax Code In Procedure Taxinn Is Invalid mf



    Hi sap guri's

    I am facing problems in CIN,I have assigned pricing procedure JINFAC tax procedure TAXINN,I also created tax codes and tax juriduction codes.

    I have also created condition records for PR00,JEXP,JLST,JCST,JCEP but when creating sales order condition like PR00,JEXP,JCEP are come automatically but system coudnot determine JLST OR JCST automatically,I have to enter manually and proced then while realising billing document to accounting, System give error msg that "Tax code in procedure TAXINN is invalid"

    Please suggest solution it's urgent"

    Thanks in Advance

    kapildev

    DB:3.19:Tax Code In Procedure Taxinn Is Invalid mf


    Hi sap guri's

    I am facing problems in CIN,I have assigned pricing procedure JINFAC tax procedure TAXINN,I also created tax codes and tax juriduction codes.

    I have also created condition records for PR00,JEXP,JLST,JCST,JCEP but when creating sales order condition like PR00,JEXP,JCEP are come automatically but system coudnot determine JLST OR JCST automatically,I have to enter manually and proced then while realising billing document to accounting, System give error msg that "Tax code in procedure TAXINN is invalid"

    Please suggest solution it's urgent"

    Thanks in Advance

    kapildev

  • RELEVANCY SCORE 3.18

    DB:3.18:Error While Creating Quality Notification In Qm01 k3



    I entered material, customer code other mandatory field pressed enter. But I get error which says "Enter a function". Error details are as below:

    Enter a function

    Message no. IX008

    Diagnosis

    You have entered a partner without entering the appropriate function.

    Procedure

    Enter the function for the partner.

    Please help.

    DB:3.18:Error While Creating Quality Notification In Qm01 k3


    hi

    ther is menu item "GOTO" and click on pater. you will go the desired screen , here you maintain the pater function.

  • RELEVANCY SCORE 3.17

    DB:3.17:Pricing Procedure Mandatory Condition Mwst,Utx1 , Utx2 Is Missing mx



    Hi

    i have created new pricing procedure but when am creating sales order am getting Mandatory condition mwst,UTX1 , utx2 is missing where as while creating pricing i have maintained condition record but still am getting error kindly help.

    Thanx

    DB:3.17:Pricing Procedure Mandatory Condition Mwst,Utx1 , Utx2 Is Missing mx


    In fact, since right now I dont have access to SAP, not sure whether in OVK1 the above Tax categories are available in standard

  • RELEVANCY SCORE 3.16

    DB:3.16:How To Manual Maintain Tax Condition Value While Creating Sales Order pp



    Hi

    I am creating one Tax condition suppose JLST without access sequence .

    while creating sales order I am manually maintain the % value of TAX. suppose it is 1%

    then I see It show some value in TAX .

    save that sales order creating delivery document for that but when I create Invoice its show error.

    " Tax code in procedure CMTAXP is invalid ".

    I know the configuration only for Tax condition with vk11 condition record .

    BUT now I want to maintain TAX condition at the time of creating sales order.

    so I remove the access sequence of that condition .

    but It shows tax code error while billing.

    My main question is that If i maintain condition record while creating sales order then how i can assign Tax code .

    Can it is possible ?

    if yes then How?

    please help me.

    thank you

    DB:3.16:How To Manual Maintain Tax Condition Value While Creating Sales Order pp


    Hi,

    The "straight-forward" answer for Tax Code creation is contact the FI consultant. He shall help you, by creating Tax codes.

    I have tested, with creating a tax cond type (copy of MWST) manually entering values. I can create Sorder, Dlv and Bill but I cannot create an Accounting document. That is because of every line (amount) a Tax code is necessary.

    I THINK, you can NOT have manually filled tax codes; access sequence is needed to get the tax value (%) and the Tax code from the condition record.

    There is lot of material on the web to understand Tax classification, code etc. etc. See a useful link below -

    http://www.sapgeek.net/2010/04/sd-determines-tax-code/

    In short Tax code is a must and take the help of your FI consultant for the configuration of the same.

    BTW - Tax code is already made created for MWST, therefore I suggested that you can use MWST. Furthermore, you can change the values corresponding to Tax codes in FTXP.

    But if you are a beginner in these things, better take help.

  • RELEVANCY SCORE 3.16

    DB:3.16:Incompletion Procedure sx



    Dear Guru's

    While Creating sales order I am not entering PO no and Incoterms (header)which are not required for my requirement, but while saving the document system is not allowing me to save the document with out enter PO# and Incoterms(In Header Data).

    What Status I have to select in Incompletion fields of Incompletion Procedure of Header Data

    My Error Procedure here I am attaching what changes I have to do

    Table Fld Name Descri Scr Status

    VBKDBSTKDPO numberKBES 00 0

    VBKDINCO1Incoterms KDE3 00 0

    Regards,

    Bhanu

  • RELEVANCY SCORE 3.16

    DB:3.16:Could Not Find The Stored Procedure : Sp_Dboption Error While Creating Load Test Repository In Microsoft Vsts 2010 Ultimate sd


    when we try to create load test repository using loadtestresultsrepository.sql in SQL Server, we encounter an error saying Could not find the stored procedure : sp_dboption error
    Pls let me know what needs to be fixed ASAP.

    DB:3.16:Could Not Find The Stored Procedure : Sp_Dboption Error While Creating Load Test Repository In Microsoft Vsts 2010 Ultimate sd

    Hi,
    Please install the VS2010 SP1, check it again.
    Please also check the detailed steps about “How to: Create a Load Test Results Repository Using SQL”.
    Do you use the SQL Server2012? If so, please refer:
    VS 2010 Test Controller / SQL Server 2012 - Could not find stored procedure 'sp_dboption'

    Best Regards,Jack Zhai [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.15

    DB:3.15:Pricing Procedure da



    Hello Gurus

    While creating PO, i'm getting error message for pricing in conditions tab.

    it throws error message "provision key missing for condition type FRA1(FREIGHT) in schema RM0002".

    where do you think it has gone wrong while defining pricing procedure.

    Cheers and thanks in advance.

    DB:3.15:Pricing Procedure da


    Hi Reddy,

    Check your pricing procedure. Go toRM0002 and maintain the account keys for frieght as mentioned by Dipak. This account key helps to post the fireght amount to the relevant frieght clearing account. In your case system was not able to find the GL account as you have not mentioned it. Once you maintain them it will solve your problem

    regards

    Anand.C

  • RELEVANCY SCORE 3.15

    DB:3.15:Foreach Loop Erro While Creating Procedure? 3d


    hello all, i am creating a proceudre with foreach loop, created with compilation error. please correct me if some mistake is there...

    CREATE PROCEDURE update_list
    DEFINE name VARCHAR(30);
    DEFINE address VARCHAR(255);
    begin
    FOREACH namedCursor FOR
    SELECT ename, eaddress INTO name, address FROM emp
    INSERT INTO mailing_list VALUES(name, address);
    IF(ename="McAllister") THEN
    UPDATE emp SET sal = sal + 2000 WHERE CURRENT OF namedCursor;
    CONTINUE FOREACH;
    END IF
    UPDATE emp SET sal = sal + 1000 WHERE CURRENT OF namedCursor;
    END FOREACH;
    END PROCEDURE

    thanks
    yash

    mailing_list table is created with field.

    DB:3.15:Foreach Loop Erro While Creating Procedure? 3d

    Double post - here is the answered thread: {thread:id=2272279}

  • RELEVANCY SCORE 3.15

    DB:3.15:Prob In Creating A Navigational Attribute 93



    hi to all

    I am trying to create a navigational attribute named " m_type " for the char "material".

    i have created the char "material" and while creating the navi attriubute it show this error

    Char. M_TYPE is exclusively an attribute (cannot be a navigation attribute)

    Message no. R7473

    help me in clearing this error

    or say the procedure to create an navigational attribute

    thank u in advance

    DB:3.15:Prob In Creating A Navigational Attribute 93


    PROB SLOVED

    THANK U FOR ALL UR VALUBLE COMMENTS

  • RELEVANCY SCORE 3.15

    DB:3.15:Please Help Me To Sort Out This Issue a3


    Hi,

    I have two user MAIN_USER and TMP_USER both have DBA,CONNECT,RESOURCE privileges.

    While I am creating the below procedure in MAIN_USER, I am getting the error ORA-00942: table or view does not exist in the insert statement line FROM TMP_USER.PROD_MASTER.

    CREATE OR REPLACE PROCEDURE MAST_UPLOAD IS
    BEGIN
    INSERT INTO PROD_MAST
    (SELECT *
    FROMTMP_USER.PROD_MASTER);
    END;

    Please help me to sort out this issue.

    Thanks,
    Jen.

  • RELEVANCY SCORE 3.15

    DB:3.15:Error While Running Procedure! 1s


    Hello there,

    I am creating a procedure and I have the following query:

    x_cnt := (Select ltrim(rtrim(to_char(count(*)+1,'0000'))) from retailer_applicants where
    retailer_code like (x_code||'%');

    While running the procedure I having an error related to the 'like' part.

    Can anyone please help me in where I might have gone wrong.

    Many thanks
    Gunajee.

    DB:3.15:Error While Running Procedure! 1s

    gunajee wrote:
    x_cnt := (Select ltrim(rtrim(to_char(count(*)+1,'0000'))) from retailer_applicants whereThe LTrim() and RTrim() functions could be replaced with a single call to Trim(), but trimming can be avoided by using the "fill mode" format modifier to toggle off Oracle's blank padding of a positive number:

    Select to_char(count(*)+1,'FM0000') from retailer_applicants where ...

  • RELEVANCY SCORE 3.15

    DB:3.15:Specify Either Normal Transactions Or A Special G/L Transactions. zs



    while creating dunning procedure fbmp, i got following error.

    specify either normal transactions or a special G/L transactions.

    i already create the special g/l transactions.

    DB:3.15:Specify Either Normal Transactions Or A Special G/L Transactions. zs


    Hi,

    In the transaction FBMP, you have check boxes for "Standard transaction" and "Special G/L". Select the appropriate check box.

    Regards

    Sreekanth

  • RELEVANCY SCORE 3.15

    DB:3.15:Client 800 Does Not Contain An Active Application Area j9



    Hi ,

    While creating a BP through t code BP system through below mentioned error mesg .

    I just config Treasury module and this is first time iam creating a BP in treasury.

    Client 800 does not contain an active application area

    Message no. 0149

    System Response

    Error message; processing was interrupted

    Procedure

    Procedure for System Administration

    Enter your application area as an active application area in Customizing for contract accounts receivable and payable.

    Pls let me know if any this is missing

    Regards

    Prakash Sharma

    DB:3.15:Client 800 Does Not Contain An Active Application Area j9


    HI,

    Please check customizing at the following path:

    Financial Accounting (New) - Contract Accounts Receivable and Payable - Basic Functions - Application Area

    Please read the IMG help and activate the application area.

    thanks,

    Kumar

  • RELEVANCY SCORE 3.15

    DB:3.15:Error Msg In Fn xp


    while creating a fn. i am getting the following error message
    what may be the pbm

    PLS-00103: Encountered the symbol "SELECT" when expecting one of
    the following:
    begin function package pragma procedure subtype type use
    an identifier a double-quoted delimited-identifier form
    current cursor
    The symbol "begin" was substituted for "SELECT" to continue.

    DB:3.15:Error Msg In Fn xp

    Create of replace Function fnmae returns xys
    is
    declareation of variables/cursrors ;
    Begin
    select etc etc
    end fname;

    check if ur code meets all the same.. do paste ur code out here

  • RELEVANCY SCORE 3.15

    DB:3.15:Error While Creating Procedure zk


    i am creating the procedure which is having year as arguemnt (i am couting total number of user in year)

    CREATE OR REPLACE PROCEDURE sample1 (a_year varchar2(4)) IS

    BEGIN
    select COUNT(*) Total_Count
    from users a
    where a.create_dt = TO_DATE('01-JAN-'a_year, 'dd-mon-yyyy' )
    and a.create_dt = TO_DATE('31-DEC'a_year, 'dd-mon-yyyy' );

    END sample1;

    DB:3.15:Error While Creating Procedure zk

    Change your code as below:
    CREATE OR REPLACE PROCEDURE sample1 (a_year char,p_Parent_RS IN OUT SYS_REFCURSOR) IS
    t_CursorPtr SYS_REFCURSOR;
    BEGIN
    OPEN p_Parent_RS FOR
    select 'NEW ITEMS CREATED' Column_Name, COUNT(*) Total_Count
    from attribs a
    where a.create_dt = TO_DATE('01-JAN-'||a_year, 'dd-mon-yyyy' )
    and a.create_dt = TO_DATE('31-DEC-'||a_year, 'dd-mon-yyyy' )
    union all
    -- new locations count
    select 'NEW LOCATION COUNT' Column_Name, COUNT(*) Total_Count
    from location a
    where a.create_dt = TO_DATE('01-JAN-'||a_year, 'dd-mon-yyyy' )
    and a.create_dt = TO_DATE('31-DEC-'||a_year, 'dd-mon-yyyy' )
    union all
    -- new interface nodes
    select 'NEW INTERFACE NODE' Column_Name, COUNT(*) Total_Count
    from interface_node a
    where A.create_dt = TO_DATE('01-JAN-'||a_year, 'dd-mon-yyyy' )
    and a.create_dt = TO_DATE('31-DEC-'||a_year, 'dd-mon-yyyy' )
    union all
    -- # of items with attributes
    select 'ITEMS WITH ATTRIBUTE' Column_Name, COUNT(*) Total_Count
    from attribs
    where label_name_code not like '0'
    --and component_code not like '0'
    and item_act_inact_status = 'A'
    and product_type_code IN ('FG','SF','BULK','SAM')

    union all
    -- total # of users
    select 'TOTAL NUMBER OF USER' Column_Name, COUNT(*) Total_Count
    from users a
    where a.stat_code = 'A';
    END sample1;

  • RELEVANCY SCORE 3.15

    DB:3.15:Overall Relese For Pr xj


    Hi,Following setting has done for the PR release1.overall relase for doc type 2. Overall relase for Release groupAnd all setting has done in set up procedure and system shows that no error re requisns. w. overall release but while creating PR Release strategy is not triggeringIs there any setting has to maintain?Regards,Renuga.A

    DB:3.15:Overall Relese For Pr xj

    Dear Renuga,Please kindly check if user exit EXIT_SAPLEBND_001 have been exit in your system via transaction CMOD.If it had beenactive, please kindly deactivate and retest.Best Regards,Ian Wong Loke Foong

  • RELEVANCY SCORE 3.15

    DB:3.15:Java Store Procedure Error sj


    Hi, I'm trying to deploy a java store procedure using Jdeveloper 3.1 but I have the next error:

    ...
    initialization complete
    loading : TimestampFormatter
    creating : TimestampFormatter
    Error while retrieving errors for TimestampFormatter
    ORA-00904: invalid column name
    loading : META-INF/MANIFEST.MF
    creating : META-INF/MANIFEST.MF
    Error while creating resource META-INF/MANIFEST.MF
    ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler
    loading : connections.properties
    creating : connections.properties
    Error while creating resource connections.properties
    ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler
    resolver :
    Error while resolving class TimestampFormatter
    ORA-00904: invalid column name
    loadjava: 4 errors
    *** Errors occurred while loading the archive into JServer ***
    *** Deployment completed ***

    I hope that someone can help me with this. Thanks a lot.
    (oracle ver. 8.1.7)

    DB:3.15:Java Store Procedure Error sj

    I have the same problem and posted the error message.

    I replied to see this message bring up to the Java Gurus.

    Thanks in advace..
    Kurian -:-

  • RELEVANCY SCORE 3.14

    DB:3.14:Error During Notification Creation 3j



    Dear all,

    I am encountering problem while creating a notification, the error is as follows,

    "Partner function AO is not allowed in partner determination profile ZPM

    Message no. IX007

    Diagnosis

    You have not entered a valid partner function.

    Procedure

    Use the function for possible entries to find a valid partner function."

    Kindly help me.

    NNR

    DB:3.14:Error During Notification Creation 3j


    Dear all thanks for the help. Actually there was an user exit activated with reference to QM module. In that they have maintained PM notification nominclature, so it was throwing the error.

  • RELEVANCY SCORE 3.14

    DB:3.14:Error While Creating Stored Procedure xk


    Hi,Getting error "java.io.IOException" while creating stored procedure. For details refer the attachments.This error comes up only with HANA database HPO (lddbhpo.wdf.sap.corp:30215).But when i use different HANA database, i'm able to create the same stored procedure.Is it something to do with HANA DB roles OR is it related to HANA studio (ver 45).Regards,Sunil

    DB:3.14:Error While Creating Stored Procedure xk

    Hi,Getting error "java.io.IOException" while creating stored procedure. For details refer the attachments.This error comes up only with HANA database HPO (lddbhpo.wdf.sap.corp:30215).But when i use different HANA database, i'm able to create the same stored procedure.Is it something to do with HANA DB roles OR is it related to HANA studio (ver 45).Regards,Sunil

  • RELEVANCY SCORE 3.14

    DB:3.14:Pricing Error d1



    Hi all,

    While creating a sales order, I am getting an error "PRICING ERROR: MANDATORY CONDITION IS MISSING".

    I have already entered condition record in VK11 and checked the pricing procedure and condition type.

    Please help.

    Regards and thanks in advance

    Swaroop

    DB:3.14:Pricing Error d1


    Hi,

    has ur error solved.

    Ramesh.

  • RELEVANCY SCORE 3.14

    DB:3.14:Is It Possible To Call A Oracle Packaged Storedprocedure Through 13



    Is it possible to call a oracle packaged storedprocedure through

    Deski?

    Also

    Receiving error when creating desktop intelligence report while using a

    stored procedure that retrieves data from globaltemporary table. Error

    message is " Object no longer exists". This same procedure can be

    successfully executed from eitherOracle SQL Plus or Crystal Reports.


    Any ideas , please help?

    DB:3.14:Is It Possible To Call A Oracle Packaged Storedprocedure Through 13


    It is possible to report off Stored Procedures in BusinessObjects Desktop Intelligence XIR2. What you need to do is to configure your Stored Procedure as a data source. If you use parameter please make sure that the default database is set to the database that contains the stored procedure.

    e.g. Click the correct DSN for the stored procedure. Click Configure.Click Next until the Change the default database to option appears.Change the default database to the database that contains the stored procedure.

    I hope this helps,

    Regards,

    Tim

  • RELEVANCY SCORE 3.12

    DB:3.12:Times Ten Error While Creating Table Via Sas z9


    Error attempting to CREATE a DBMS table. ERROR: CLI execute
    error: [TimesTen][TimesTen 7.0.3.0.0 ODBC
    Driver][TimesTen]TT2918: Precision of number type is out of range [1,38] -- file "ptSqlY.y", lineno 4006, procedure "coltype : NUMBERSQ LPAREN integer COMMA minusopt integer RPAREN".
    NOTE: The data step has been abnormally terminated.

    DB:3.12:Times Ten Error While Creating Table Via Sas z9

    I believe you need to trace what SQL commands SAS is sending to TimesTen. I'm not familiar with SAS but some quick research suggests the "sastrace" option might help you? e.g http://www.sas.com/partners/directory/ibm/db2_sas9.pdf

  • RELEVANCY SCORE 3.12

    DB:3.12:Sales Order Error 8p



    Hi

    While creating sales order i am getting an error.

    No pricing procedure could be determined

    Message no. V1212

    Diagnosis

    The appropriate pricing procedure could not be determined because no entry with keys 'Cocde Distrchannel Division' 'A' '1' exists in table 683V.

    System Response

    The system does not allow further processing of the document.

    Procedure

    If necessary and if you have the authorization to do so, add the missing entry using the Customizing tool for determining pricing procedures.

    How can i solve this?

    regards

    N Banu

    DB:3.12:Sales Order Error 8p


    Hi,

    As in the earlier mails, you need to make sure that the enterprise structure is perfect. Whenyou create the sales order, the when the system finds the material is relevent for pricing from the item category, it check for the pricing procedure. This need to be assigned in SPRO -- SD -- Basic functions -- Pricing -- pricing procedure determination.

    You need to assigne the pricing procedure to your sales area + Customer Pricing Procedure (maintained in the customer master) + document pricing procedure (maitained in the sales document type) + Pricing procedure.

    The standard will be:

    XXXX YY ZZ 1 A RVAA01 PR00.

    Prase

  • RELEVANCY SCORE 3.11

    DB:3.11:Error Handling While Calling Bapi ? k3



    Hi all,

    I am calling 'BAPI_GOODSMVT_CREATE' from a program to create goods receipt with purchase order. Eventhough i am successfully creating the Goods Receipt , i am unable to display the error messages if Goods Receipt is not created.

    Please help me on displaying the error messages by specifying procedure and coding ?

    Thanks,

    Vamshi.

    DB:3.11:Error Handling While Calling Bapi ? k3


    Hi,

    .

    .

    DATA: LT_RETUTN TYPE TABLE OF BAPIRET2.

    .

    .

    CALL FUNCTION 'BAPI_GOODSMVT_CREATE'

    EXPORTING

    goodsmvt_header =

    goodsmvt_code =

    TESTRUN = ' '

    IMPORTING

    GOODSMVT_HEADRET =

    MATERIALDOCUMENT =

    MATDOCUMENTYEAR =

    TABLES

    goodsmvt_item =

    GOODSMVT_SERIALNUMBER =

    return = lt_return.

    .

    ASSIGN OTHER PARAMETERS

    You will get the message details in the lt_return internal table. Kindly refer the structure BAPIRET2 for the field details.

    Hope, this will help you. Kindly reply if you need more details.

    Reward, if it is useful ...

    Regards,

    SK.

  • RELEVANCY SCORE 3.11

    DB:3.11:Table Doesn't Exist Error While Creating A Procedure 93


    The query executes and retrieve records but when the query is put into a procedure , the procedure is giving error (4/30 PL/SQL: ORA-00942: table or view does not exist) during creation. The snurk_cmms_csht008_rfs_misc is a public synonym refering to db2 database. How to make the procedure to get created ?

    SQL CREATE PROCEDURE TEST AS
    2 I VARCHAR2(20);
    3 BEGIN
    4 SELECT CD_PLANT INTO I FROM snurk_cmms_csht008_rfs_misc
    5 WHERE ROWNUM 2;
    6 END;
    7 /

    Warning: Procedure created with compilation errors.

    SQL SHOW ERRORS;
    Errors for PROCEDURE TEST:

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    4/2 PL/SQL: SQL Statement ignored
    4/30 PL/SQL: ORA-00942: table or view does not exist

    SQL SHOW USER;
    USER is "ORDV_SRC"

    SQL SELECT CD_PLANT FROM snurk_cmms_csht008_rfs_misc WHERE ROWNUM 2;

    CD_PL
    -----
    AP01A

    thanks,
    Vinodh

    DB:3.11:Table Doesn't Exist Error While Creating A Procedure 93

    I can't get what you say. If the procedure works the package should also work. My issue is resolved. My dba did for me but do not know how he resolved.

    thanks.

  • RELEVANCY SCORE 3.11

    DB:3.11:Tax Code In Procedure Taxd Is Invalid? 3j


    HI,While Creating the sales Order ia m getting the error message ....Pricing Error: Mandatory Condition MWST Is Missing.For this i have entered the condition type by VK11-- MWSTThen i am getting another error message....Tax Code in Procedure TAXD is invalid.

    DB:3.11:Tax Code In Procedure Taxd Is Invalid? 3j

    HIAlso just check what are the condition types availabel for TAXD in vk11 and assign the same in vk11regards

  • RELEVANCY SCORE 3.11

    DB:3.11:Pricing Error In Billing Document xd



    Dear All,

    I have an issue in billing.

    My Sales Document Type is ZOR1 and ZZIN is the Pricing Procedure.

    While creating sales order, the correct pricing procedure is picked, but when I go to billing; a different pricing procedure is being picked.

    All determinations have been correct. I have checked in VTFA too.

    Kindlly suggest where I might be wrong.

    Thanks and Regards,

    Adithya

    DB:3.11:Pricing Error In Billing Document xd


    Thanks Guys,

    The issue is solved. It was a situation wherein I had to create a new billing type and assign the same document pricing procedure which was used in the sales document to it. I have done the same and it working fine. Points awarded to all.

    Thank and Regards

    Adithya

  • RELEVANCY SCORE 3.11

    DB:3.11:Cannot Creat Rfqs And Contracts m7



    This is Naresh, beginner in SAP-MM. While creating RFQs and contracts, i am getting an error called "company code not assigned to country or country to calculation procedure". Anyone please clear my error. Thanks in advance.

  • RELEVANCY SCORE 3.10

    DB:3.10:Probelm While Creating Procedure 8f


    Hi All,

    I am trying to create a store procedure that reads data from source schema and inserts the data into the destination table in some other schema on a different database via database link.

    Below is the sample procedure:

    create or replace procedure test
    as
    begin
    INSERT /+ APPEND NOLOGGING ALL /

    INTO OWNER.A@DB
    SELECT * FROM OWNER.A;
    commit;
    end;
    */*

    When I am creating the above procedure is am getting below error:
    PL/SQL: ORA-01031: insufficient privileges

    But if I am firing the insert query from the above procedure at SQL prompt, its working fine.
    INSERT / APPEND NOLOGGING ALL */+*
    INTO OWNER.A@DB
    SELECT * FROM OWNER.A;

    Also, I am creating the procedure and firing the query in the same database using same userid.

    Can anyone please let me know what kind of privileges do I need to give or how to go about it?

    Regards,
    Amol

    Edited by: amolpatre on Oct 15, 2008 2:00 PM

    DB:3.10:Probelm While Creating Procedure 8f

    Hi,

    pls check this thread, may be userful.

    ORA-01031: Insufficient privileges

  • RELEVANCY SCORE 3.10

    DB:3.10:Create Objective Template - Error 3k


    Hi,

    I am creating objective template while I am creating an Appraisal template using "Manage Appraisal Template" function in core HR. While I am saving objective template in "Create Objective Template" page, I am getting the following error:

    "Database constraint violated. The database check or unique constraint PER_ASSESSMENT_TYPES_UK1 has been violated. Please contact your system administrator quoting the package procedure per_ast_shd.constraint_error and constraint PER_ASSESSMENT_TYPES_UK1"

    Any idea?

    Thanks in advance.

    MAK

    DB:3.10:Create Objective Template - Error 3k

    HR FP.K RUP3 contains many Talent Management patches too. I would advise getting to the latest version of the TM RUP patches, whether through HR FP.K RUP3 or individually.

  • RELEVANCY SCORE 3.10

    DB:3.10:Message Error In Gp 83



    Hello experts

    I have a question for you, let me know how can I fix this error, that appears on guided procedure (Netweaver 7.0) while creating any callable object

    The error message follows: Cannot create object Cannot persist parameter list

    Thanks

    DB:3.10:Message Error In Gp 83


    Hello experts

    I have a question for you, let me know how can I fix this error, that appears on guided procedure (Netweaver 7.0) while creating any callable object

    The error message follows: Cannot create object Cannot persist parameter list

    Thanks

  • RELEVANCY SCORE 3.10

    DB:3.10:Loadjava Hangs! Ora-04021 xp


    After successfully loading a java stored procedure serval times, I suddenly received the following error during loadjava:

    "Error while creating xmlProduct ORA-04021: timeout occurred while waiting to lock object SYSTEM.xmlProduct"

    I have gone so far as to restart the database, but the error persists. What is causing this? I'm dead in the water until I can clear this hurdle...please help.

    DB:3.10:Loadjava Hangs! Ora-04021 xp

    Kenneth,
    I am trying to load the first jar file into our Oracle8i database . I am getting "Compatible parameters needs to be 8.1.0.0.0 or greater" error. I used TNS as well as thin driver to load the jar.

    thanks
    raj

  • RELEVANCY SCORE 3.10

    DB:3.10:Exports Procedure In India sa



    can someone help me with configuring exports procedure in india.std pricing procedure(condition based ) has no excise condition types so haw will the values get populated while creating are1.

    regards

    ashish

    DB:3.10:Exports Procedure In India sa


    if you can provide me your email id, I will forward an document on CIN configuration, which may be of some use to you.

    Regards,

    Rajesh Banka

    Reward points if helpful.

  • RELEVANCY SCORE 3.10

    DB:3.10:Condition Value Error 8f



    Dear all,

    I have condition type JEXC (In Manual Excise) In my Pricing Procedure. i am imposing 16% in this condition while creating PO. The condition value is calculating and includes in the net price and shows in the top in Net field.

    I want the net value to shows at the last row in my pricing procedure. How to modify it.

    please suggest your valuable advice regarding this.

    Regards

    Prasant

    DB:3.10:Condition Value Error 8f


    Hi,

    place the Net price at the bottom of the pricing procedure,

    Include the step numbers FROM and TO properly.

    Thanks regards,

    Kiran

  • RELEVANCY SCORE 3.10

    DB:3.10:Insufficent Priviledge zp


    i got this error while creating table in procedure in my scema. so may i know which right require to create table in runtime in procedure.
    plz reply

  • RELEVANCY SCORE 3.10

    DB:3.10:Error While Creating An Employee sp


    While doing one transaction in People screen i got the below error

    APP-PER-289974:There has been an error Processing this Person. The Error is encountered is Which occurred in procedure per_hrtca_merge.update_tca_person at step 10

    if any body is having solution for above please let me know

    regards
    Jagadeesh

    DB:3.10:Error While Creating An Employee sp

    Hello

    Refer metalink note PERWSHRG APP-PER-289974 Updating Email Address [ID 731386.1] , it may help you.

    Thanks
    Gaurav

  • RELEVANCY SCORE 3.10

    DB:3.10:Specify Either Normal Transactions Or A Special G/L Indicator xs



    dear friends,

    while creating dunning procedure, the foll error is displayed,
    Specify either normal transactions or a special G/L indictaor
    unable to create the next tabs like, dunning levels, dunning texts, etc..

    pl help me out.

    thanks.

  • RELEVANCY SCORE 3.08

    DB:3.08:Error In Tax Code While Creating A Po In T.Code Me21n dk



    Hi,

    I am trying to create purchase Order, I am getting an error when while entering this

    Tax Code : v1

    Jurisdict. Code: RS14902

    The error is "Tax code v1 in procedure TAXBRJ is Invalid"

    How to rectify this error. Or

    What can be other way of entering the tax code and jurisdict code

    DB:3.08:Error In Tax Code While Creating A Po In T.Code Me21n dk


    Hi,

    Go to the Table T007A, where you find the tax codes.

    Input out put taxes are the tax types.

    In FTXP T.code give the tax code and click on the

    Input tax codes are used for purchase cycle and out put taxes are for sales cycle. I Hope you have given the sales related tax code. Thats why system is giving the error message.

    In T007 Table give the proper input and get the details.

    Regards,

  • RELEVANCY SCORE 3.08

    DB:3.08:Error In Dependency mc



    Dear

    while creating the dependency i received the following error.

    E28151 Table ZPPSFCTWEFT does not exist

    E28024 Syntax error in simple action/procedure

    although the table is already created and activated but this message is received on ly in case of procedure selected in cu01

    regards

    s.m.pandit

  • RELEVANCY SCORE 3.08

    DB:3.08:Database Error Text: Invalid Number xx



    Hi Gurus,

    I am calling a procedure proxy from ECC and it is giving me a short dump:

    Error 339 has occurred while executing database procedure

    ""_SYS_BIC"."Krishna_Demo_Proj.Model/KC_GET_MARA"" on the

    current database connection "R/3".

    Database error text: invalid number: ''

    Triggering statement: "dsql_open_proc"

    I have created a table with only one field.

    Mapped the Data types after creating the Procedure Proxy

    Which data type I need to use? I tried with lots of combinations but, still the same error.

    Regards,

    Krishna Chauhan

    DB:3.08:Database Error Text: Invalid Number xx


    Hi Srinu,

    I have used NVARCHAR 18 and corresponding to that CHAR18 is used.

    Please see the attached screen shots.

    Regards,

    Krishna Chauhan

  • RELEVANCY SCORE 3.08

    DB:3.08:Fi_Tax_Chk_Pricing_Data Error 3x



    Hi

    I am facing this error while creating Purchase order

    can anyone tell me how to solve this

    System error in routine FI_TAX_CHK_PRICING_DATA error code 13 function builder TAX2

    Message no. FF769

    Diagnosis

    A serious program error has occurred.

    System Response

    The current processing step cannot be carried out.

    Procedure

    If the program error occurred

    In a standard SAP program, then create an OSS message

    In a program you wrote yourself, then correct the program.

    DB:3.08:Fi_Tax_Chk_Pricing_Data Error 3x


    I think the error is not in Custom routine but in configuartion. Try checking if you encounter the same problem when using different pricing schema. That might give some clue.

    Regards

    Eswar

  • RELEVANCY SCORE 3.08

    DB:3.08:S Order 83



    Hi,

    While creating sales order system showing error that The appropriate pricing procedure could not be determined because no entry with keys '2000 20 GZ' 'Z' '' exists in table 683V.

    Please give me the solution to solve this.

    Thanks,

    Rajesh.

    DB:3.08:S Order 83


    It appears that you havent assigned any customer pricing procedure in the customer master for the sold to which you are processing the sales order.

    Please check the customer master data of this sold to and in sales area data - -sales area-assign the appropriate customer pricing procedure to the customer(use T.code XD02)

    Regards

    Sai

  • RELEVANCY SCORE 3.08

    DB:3.08:Template Material Processing Is Deactivated c8



    While creating the credit memo with new documnet type i am getting this error.

    Please let me step by step procedure to over come this error.

    "Template material processing is deactivated"

    Regards,

    Madhu

    DB:3.08:Template Material Processing Is Deactivated c8


    Hi guru's,

    Please provide some inputs.

    When i am creating a creditmemo request using CR, after entering the material and plant detailes it is giving the fallowing error message.

    Template material processing is deactivated

    Reg,

    Madhu.

  • RELEVANCY SCORE 3.08

    DB:3.08:Error While Creating Stored Procedure dp


    Hi,I'm trying to create a stored procedure using HANA studio (Ver 45). But getting error "java.io.IOException: Error loading object, refer to Repository Log for more information". Refer attached document for more details.Current HANA DB we are using is HPO : (lddbhpo.wdf.sap.corp:30215) where we are facing the above mentioned issue.But when i tried to create the same procedure in another HANA database, it worked. So i'm bit unclear whether its an issue with Studio or something specific to database.Regards,Sunil

    DB:3.08:Error While Creating Stored Procedure dp

    Hi All,This issue is due to version mismatch between the HANA DB server and the studio.So after the upgrade of HANA studio, the issue was solved.Regards,Sunil

  • RELEVANCY SCORE 3.07

    DB:3.07:Order Creation 3a



    Dear Friends,

    While creating the sales order in CRM from CRMD_ORDER it gives me an Error message saying "Pricing data for partner xxxxxxx could not be read", Pricing Procedure could not be determined...

    Can anyone give me hints on what to check? thanks and regards,

    Lata.

    DB:3.07:Order Creation 3a


    check the pricing procedure from where it taking i.e CRM Pricing, IPC or any other System.

    you should choose CRM Pricing if it is CRM Standalone.

  • RELEVANCY SCORE 3.07

    DB:3.07:Problems Loading A Java Stored Procedure 17


    I am running Oracle 8i v. 8.1.5.1 and getting the following error message when I am trying to load a java stored procedure using the loadjava utility.

    initialization complete
    loading : OracleProcs
    creating : OracleProcs
    Error while creating OracleProcs
    ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

    resolver :
    Error while resolving class OracleProcs
    ORA-00904: invalid column name

    loadjava: 2 errors

    What do I need to specify for the compiler to find the missing class?

    Nils

    DB:3.07:Problems Loading A Java Stored Procedure 17

    I am running Oracle 8i v. 8.1.5.1 and getting the following error message when I am trying to load a java stored procedure using the loadjava utility.

    initialization complete
    loading : OracleProcs
    creating : OracleProcs
    Error while creating OracleProcs
    ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

    resolver :
    Error while resolving class OracleProcs
    ORA-00904: invalid column name

    loadjava: 2 errors

    What do I need to specify for the compiler to find the missing class?

    Nils

  • RELEVANCY SCORE 3.07

    DB:3.07:Tax Code In Procedure Taxinn Is Invalid fk



    Hi Gurus,

    While creating sales order along with project system, I am facing the following problem

    "Tax code in procedure TAXINN is invalid" for single item which is bought out. For finish item I am not getting any error.

    Kindly guide me how to solve this problem and why this is coming for bought out

    Rajesh

  • RELEVANCY SCORE 3.07

    DB:3.07:Credit Price 8a



    While creating Sales order,system is giving an error, maintain credit Price for Item.

    Missing data: Credit price

    Message no. VU019

    Diagnosis

    The system checked the document for completion and found some missing data.

    System Response

    You cannot continue processing.

    Procedure

    Enter the missing data.

    DB:3.07:Credit Price 8a


    Thanks for your help. Error get resolved with your help.

  • RELEVANCY SCORE 3.07

    DB:3.07:An Error Occurred While Creating Service ca



    when i try to rollout that it giving error as "an error occurred while creating service"


    DB:3.07:An Error Occurred While Creating Service ca


    Oops, sorry i should have clicked on the image to see it better.

    Have you read the troubleshooting guide that @John gave you? It should solve all the issues you have with unmanaged devices.

  • RELEVANCY SCORE 3.07

    DB:3.07:Shipment Cost m3



    Hi Experts..

    While creating Shipment VT01N in shipment cost tab - Pricing Procedure is not capturing in Procedure.

    When i Change shipment i can able to select Pricing Procedure in Procedure.

    I want the system should capture directly without inputing Defined Pricing procedure in Procedure Tab.

    Kindly give your inputs.

    Thanks

    Shri..

    DB:3.07:Shipment Cost m3


    Hi Mr, Shrii,

    Looks like the pricing procedure has not been maintained for the given inputs.

    Transportation planning point

    Item determination procedure group

    Service agent group

    Shipping type group

    Please maintain it in T-code T_73

    Hope this helps.

    Regards,

    MT

  • RELEVANCY SCORE 3.07

    DB:3.07:Error When Creating A Procedure Using Hana Studio xz



    Hi,

    I am encountering an error while trying to create a procedure using HANA studio.

    Please find here with the error details and please suggest.

    * error

    Repository: Encountered an error in repository runtime extension;error preparing statement create procedure

    "_SYS_BIC"."roby-hana-practice/ZPROC" ( out COUNTRY_NAME "_SYS_BIC"."roby-hana-practice/ZPROC/tabletype/COUNTRY_NAME" , in CUSTOMER_ID "_SYS_BIC"."roby-hana-practice/ZPROC/tabletype/CUSTOMER_ID" ) language SQLSCRIPT sql security definer as

    n /********* Begin Procedure Script ************/

    n BEGIN

    nn SELECT "RM_SD_HANA"."CUSTOMER".COUNTRY_NAME

    n FROM "RM_SD_HANA"."CUSTOMER"

    n WHERE "RM_SD_HANA"."CUSTOMER".CUSTOMER_ID = CUSTOMER_ID

    n INTO COUNTRY_NAME;

    nn END;

    n /********* End Procedure Script ************/ for oid {tenant: , package: roby-hana-practice, name: ZPROC, type: 2}

    * SQL code

    BEGIN

    SELECT "RM_SD_HANA"."CUSTOMER".COUNTRY_NAME

    FROM "RM_SD_HANA"."CUSTOMER"

    WHERE "RM_SD_HANA"."CUSTOMER".CUSTOMER_ID = CUSTOMER_ID

    INTO COUNTRY_NAME;

    END;

    Output Parameter is : COUNTRY_NAME and Input Parameter is : CUSTOMER_ID.

    Schema for the Procedure is _SYS_BIC and Default schema is SYSTEM.

    Thank you,

    Tk.

    DB:3.07:Error When Creating A Procedure Using Hana Studio xz


    Hi TK,

    I have re-written your create procedure:

    create procedure "_SYS_BIC"."roby-hana-practice/ZPROC"

    ( in CUSTOMER_ID "_SYS_BIC"."roby-hana-practice/ZPROC/tabletype/CUSTOMER_ID",

    out COUNTRY_NAME "_SYS_BIC"."roby-hana-practice/ZPROC/tabletype/COUNTRY_NAME")

    language SQLSCRIPT sql security definer reads sql data as

    /********* Begin Procedure Script ************/

    BEGIN

    COUNTRY_NAME = SELECT "RM_SD_HANA"."CUSTOMER".COUNTRY_NAME

    FROM "RM_SD_HANA"."CUSTOMER"

    WHERE "RM_SD_HANA"."CUSTOMER".CUSTOMER_ID = :CUSTOMER_ID;

    END;

    /********* End Procedure Script ************/

    Note: The in and out line got wrapped, so you may want to adjust accordingly in HANA Studio.

    Can you try it on your HAN instance?

    Regards,

    Ferry

  • RELEVANCY SCORE 3.07

    DB:3.07:Error While Creating Pr sc



    Below is the error while creating a PR.

    Plz suggest.

    Period 005/Fiscal Year 2008 for not open for FM posting in value type 50

    Message no. FI_E018

    Diagnosis

    Posting for the document of value type 50 was attempted on a date that has not been opened in FM.

    Procedure

    To define open time intervals for FM postings, use the following transactions:

    Individual Maintenance of Open Time Intervals

    Mass Maintenance of Open Time Intervals

    DB:3.07:Error While Creating Pr sc


    I am Working on your Issue. Meanwhile Communicate your FI Consultants.

    Regards,

    Ashok

  • RELEVANCY SCORE 3.06

    DB:3.06:Error : Tax Code In Procedure Xxxx Is Invalid 97



    Hello Gurus,

    I have an issue with creating the condition records for tax procedure..

    I receive the error message mentioned in subject while creating the condition records...

    My access sequence is

    Sales Org/Customer Tax Cla/Material Tax Cla

    Everything is configured ina proper way, please give ur valuable

    Thanks and Regards,

    Pavan P.

  • RELEVANCY SCORE 3.05

    DB:3.05:Oracle Forms 6i 8m


    While creating a data block based on stored procedure,having table type as OUT type parameter unable to run using client server runtime.The error is given with PLSQL_TABLE.POPULATE_BLOCK in QUERY-PROCEDURE for which appropriate help is not available.

    DB:3.05:Oracle Forms 6i 8m

    Hi,

    I think you meant to post this question to the Forms 6i forum. This is the JDeveloper forum, a different tool.

  • RELEVANCY SCORE 3.05

    DB:3.05:Error In Condition Supplement zx



    Dear Friends,

    During Creating condition supplements i am getting and error,

    While maintaining a condition supplement for a condition K004 i am adding K007 as supplement, while maintaining in condition record when i try to enter K007 as condition supplement, it give an error that *Requirements for Condition type K004 is not fulfilled *

    i have assigned a both the conditions to Account key and everything is fine in pricing procedure

    Please help me

    Regards

    DB:3.05:Error In Condition Supplement zx


    Hi,

    Just check in V/08, your assigned Pricing Procedure. The "Requirement" column must have "2" (Item with Pricing) should be there for both the condition types. But if you are deviating from this Requirement, then this error may result.

    Just re-check the settings as well as whether your Pricing fulfils the Requirement.

    Regards

    SD

  • RELEVANCY SCORE 3.05

    DB:3.05:Calling A Pal Procedure With In A Standard Procedure In Sap Hana 3c



    Hi,

    I am creating a standard SQL procedure , while including a call for PAL Procedures such as CHAID, APRIORI. I am facing a error like:

    Could not execute 'create procedure PREDICTION_ALGORITHM (IN CUSTOMER_ID integer) AS BEGIN DELETE FROM ...' in 257 ms 933 s . SAP DBTech JDBC: [7] (at 597): feature not supported: Only table variable is allowed in input parameter in a nested call: line 17 col 36 (at pos 597)

    This error is specific to statement for PAL procedure call included in the procedure. For example in my case:

    CALL _SYS_AFL.CHAID_CUSTOMER("ZOM"."CUSTOMER_CHAID_INPUT", "ZOM"."CUSTOMER_CONTROL_TAB", "ZOM"."CUSTOMER_JSONMODEL_TAB", "ZOM"."CUSTOMER_PMMLMODEL_TAB");

    Is it a product limitation!?

    Warm Regards

    Sushant Jain

    DB:3.05:Calling A Pal Procedure With In A Standard Procedure In Sap Hana 3c


    Hi,

    I am creating a standard SQL procedure , while including a call for PAL Procedures such as CHAID, APRIORI. I am facing a error like:

    Could not execute 'create procedure PREDICTION_ALGORITHM (IN CUSTOMER_ID integer) AS BEGIN DELETE FROM ...' in 257 ms 933 s . SAP DBTech JDBC: [7] (at 597): feature not supported: Only table variable is allowed in input parameter in a nested call: line 17 col 36 (at pos 597)

    This error is specific to statement for PAL procedure call included in the procedure. For example in my case:

    CALL _SYS_AFL.CHAID_CUSTOMER("ZOM"."CUSTOMER_CHAID_INPUT", "ZOM"."CUSTOMER_CONTROL_TAB", "ZOM"."CUSTOMER_JSONMODEL_TAB", "ZOM"."CUSTOMER_PMMLMODEL_TAB");

    Is it a product limitation!?

    Warm Regards

    Sushant Jain

  • RELEVANCY SCORE 3.05

    DB:3.05:Pl/Sql Procedure Is Not Creating With The Clob Data Type c7


    Hi,

    I am Using Oracle 10g Express Edition Release2.... My Doubt is While creating a table With CLOB Data Type the table is created successfully,but while Creating a Procedure With the CLOB Data type i am getting an Error Message

    2667/5 PL/SQL: Statement ignored
    2667/24 PLS-00382: expression is of wrong type

    then i tried With the Varchar2(30000) the Procedure is Created Successfully note i have not changed any thing in my code except the data type.

    I am Just Confused ......Why the Procedure is not Created with CLOB Data type?

    Please advice ...

    Thank U

    SHAN

    DB:3.05:Pl/Sql Procedure Is Not Creating With The Clob Data Type c7

    Hi,

    It might be XE or 10g version
    You could ask from PL/SQL forum

    I did find similar post from there
    execute immediate with a string longer than 32767

    Br, Jari

  • RELEVANCY SCORE 3.05

    DB:3.05:Error While Creating A Quotation ak



    hi

    i am trying to give value for pr00 while creating a quotation in conditions tab at item level for a sales bom. its shows me an error saying requirement 2 not fulfilled for condition pr00 in pricing procedure(item category tap), where as the same material holds good while creating a order. need help.

    regards

    leo

    DB:3.05:Error While Creating A Quotation ak


    thanks mate it was indeed pricing relevant field in item category.thanks.

    regards

    leo

  • RELEVANCY SCORE 3.05

    DB:3.05:Export/Import Procedure!! m1



    Hi

    I am updating Export/Import Procedure in Import tab while creating a new PO thru BAPI BAPI_PO_CREATE1 ...but the export/import procedure is not getting updated..any reason?

    Regards

    Gunjan

    DB:3.05:Export/Import Procedure!! m1


    Hi Hans,

    I am trying to create PO from frontend and for that i have copied standard PO Create BAPI. The problem is that i can pass values from frontend such as VENDOR etc.But i dont want to pass values for POHEADERX and POITEMX from frontend and so want to set them in backend itself. Can you pls tell me how to do this..

    Waiting for your valuable feedback.

    Thanks in advance,

    Rajesh

  • RELEVANCY SCORE 3.05

    DB:3.05:Calling Script In A Stored Procedure km


    I have this script and want to use it in a stored procedure but while creating it, it showed me an error:
    Error: Query : CREATE PROCEDURE test.loadXMLData() BEGIN LOAD XML LOCAL INFILE
    UserApplication.xml' INTO TABLE userapplicatio... Error Code : 1314 LOAD XML is not allowed in stored procedures
    Query:
    LOAD XML LOCAL INFILE 'UserApplication.xml'
    INTO TABLE userapplication
    ROWS IDENTIFIED BY 'Group';
    please Help me Out for finding where i m exactly making a mistake....

    DB:3.05:Calling Script In A Stored Procedure km

    I am so sorry by mistake i tag the SQL server and post into this forum thank for ur reply....

  • RELEVANCY SCORE 3.05

    DB:3.05:First Time Using Vb 2008 Ide Creating Data Source Of Any Kind...Error !!! zm


    Error: An Error Occured while retieving informationfron the database: Selecting Objects of type 'Procedure' is not supported.
    Help...This is the first time I have used this install of Vista Visual Studi 2008 VB

    DB:3.05:First Time Using Vb 2008 Ide Creating Data Source Of Any Kind...Error !!! zm

    See if this helps: QODBC connection using Visual Studio 2008Only performance counts!

  • RELEVANCY SCORE 3.05

    DB:3.05:Regarding Vat x7



    Hi Guru's

    while i am creating VAT condition record,i am getting error like this"TAXCODE in procedure TAXZA is invalid".i am creating VAT 14% for country South africa ZA.

    anyone can pls give me the step by step procedure to resolve this Query

    Thanks Regards

    Ramesh chandra

    DB:3.05:Regarding Vat x7


    Assign taxcode to the taxation procedure.

    1.While ur creatinng the condition records you have to enter the taxcode.

    2. In OB40 transaction assign taxcode to the account key with proper G/L account.

    3.Doube click on the account key you will go different screen there you select the rules and the check the box.

    reward the points if it is helpful

  • RELEVANCY SCORE 3.05

    DB:3.05:Sample Drawing Procedure - Error kc



    Dear Friends,

    While I am creating Insp.Lot through manual insp.lot creation(QA01) I am getting an error on "Sample drawing Procedure" it is "SAMPLE DETERMINATION: NO SAMPLE DRAWING ITEM FOUND" Whereas in sample drawing item I have decleared

    1) Lot container

    2)ToPartSampleNo

    3)Sample contnr

    4)Size factor and

    5)Fixed number

    in Primary samples. Please suggest me what to do next for the error coming at manual lot creation?

    Regards,

    Neel.

    DB:3.05:Sample Drawing Procedure - Error kc


    Hi Neel,

    Could you help me to solve the same problem. I'm stuck since many days :s

    Thanks ahead

  • RELEVANCY SCORE 3.05

    DB:3.05:Taxinn Procedure pp



    hi friends,

    while i am creating P.O system is giving the following error..

    " Tax jurisdiction code not allowed for tax calculation schema TAXINN"??

    I am using TAXINN procedure.

    my doubt is TAXINN procedure needed Jurisdiction code ???

    thanks

    mehar

    DB:3.05:Taxinn Procedure pp


    Hi,

    1.TAXINN is the tax procedure used in county version india for calculating taxes

    2. CIN MM module deals with calculation of Excises duties , E cess, VAT, CST , customs , Legal requirement ( like register maintainance) etc

    3. Calculation Schema : This determines how the price has to be calculated in Purchase orders.

    During the Purchase order creation we enter price and other condition for material that you are procuring, and also enter the taxcode in purchase order which calculates taxes.

    Based on the Pricing value and Taxcode (tax values ) will update the GR Value and During the Invoice verification process system will suggest the prices with taxes.

    for having the more clarity, please read the help content, link is provided below these are with screen shots

    http://help.sap.com/saphelp_erp2005vp/helpdata/en/40/a23c39129ffe2ee10000000a114084/frameset.htm

    http://help.sap.com/saphelp_erp2005vp/helpdata/en/9e/0b941b0fd64873bc54e8745fb044e7/content.htm

    Thanks Regards,

    Archit

  • RELEVANCY SCORE 3.05

    DB:3.05:This Is The Error - While Creating Access Sequence For Pricing? jp



    Hi friends

    i created the condition table and while creating access seqiuence I am getting this error ., please read the error and help me

    Diagnosis

    Field assignment has not yet been carried out.

    System Response

    When using this access sequence, the system can never find a record for this access (sequential number 05 table 951)

    Procedure

    Branch to field level and make the field assignment

    Thanks

    Kris

    DB:3.05:This Is The Error - While Creating Access Sequence For Pricing? jp


    Hi Akk

    yea you are right , i created table and there is no HIENR (customer heirarchy field) field in the table. But when I am maitaing my access sequece I am getting the above mentioned error(in the previous question) with red symbol. Please solve my problem.

    VKORG - sales org

    VTWEG - d.c

    KUNNR - customer

    PRODH product heirrarchy

    PRODH1 product heirrarchy 1

    PRODH2 product heirrarchy 2

    PRODH3product heirrarchy 3

    KFRST Release status

    KBSTAT Processing status