• RELEVANCY SCORE 5.04

    DB:5.04:Pi Datalink 9k





    Instalé el PI Datalink para Excel 2010 y al abrir Excel me despliega el error "Una de las bibliotecas de objetos (l) falta o esta dañada". El equipo tiene Windows 7, todas las actualizaciones, ya he desinstalado e instalado tanto Office 2010 como PI DataLink,
    Active View y todos los programas de Osisoft.

    DB:5.04:Pi Datalink 9k

    Hola!

    es de suponer que tendrás contratado el mantenimiento con OSI es mejor que hables con ellos y te ayudaran a resolver el problema.

  • RELEVANCY SCORE 3.69

    DB:3.69:Add-In Is Disable Automatically az





    I have installed PI-Datalink add-in in Excel 2010, it works fine but when I open an excel file with Outlook (an attached file), the add in is disable and I cannot enable again, any idea?

    DB:3.69:Add-In Is Disable Automatically az


    Hi

    Thank you for using
    Microsoft Office for IT Professionals Forums.

    Method A To re-enable an add-in in an application that uses the Ribbon

    click the
    File tab Click the
    Options button.
    In the categories pane, click
    Add-ins.
    In the details pane, verify that the add-in appears in the
    Disabled Application Add-ins list.
    The Name column specifies the name of the assembly, and the
    Location column specifies the full path of the application manifest.
    In the
    Manage box, click Disabled Items, and then click
    Go.
    Select the add-in and click
    Enable.
    Click
    Close.

    Method B To re-enable an add-in in an application that does not use the Ribbon

    In the application, open the
    Disabled Items dialog box. For instructions, see Help for the Office application.
    In the categories pane, click
    Add-ins.
    Verify that the add-in assembly appears in the list.
    Select the add-in and click
    Enable.
    Click
    Close.

    More detailed information you can refer to this article,
    How to: Re-enable an Add-in That Has Been Disabled

    http://msdn.microsoft.com/en-us/library/ms268871.aspx

    Please take your time to try the suggestions and let me know the results at your earliest convenience. If anything is unclear or if there is anything
    I can do for you, please feel free to let me know.

    Hope that helps.

    Sincerely

    William Zhou CHN

    --------------------------------------------------------------------------------
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.65

    DB:3.65:Osi Layer Question m1






    Which layers of the osi model are host to host layers ?

    1. Transport, session,Presentation, Application

    2. Network, Transport, Session, Presentation

    3. Datalink, Network, Transport, Session

    4. Physical, Datalink,Network, Transport

    Which is the correct option ?

    DB:3.65:Osi Layer Question m1


    i go ahead with jon.marshall . The answer is Transport, session,Presentation, Application are considered to be host layers

  • RELEVANCY SCORE 3.59

    DB:3.59:Multiplying Data Between Query Tables With Missing Valuesdifferent Sizes cz


    Working in Excel 2010 with PI ProcessBook Datalink.

    I'm trying to multiply numbers between two query tables in Microsoft Excel. The tables are sorted by date, one set of values for each day. I'm trying to put the table information into arrays using VBA to perform further calculations. The tables at the bottom
    shows an example of the data. The first table contains a full list of data over an 8 day period. The second table has a missing value for 4/6. These queries come locked as is in rows and I am unable to put in dummy rows with empty values. I want to be
    able to multiply the values 4/1 by 4/1 etc. and be able to fill a one dimensional array in VBA with 8 values using a 0 to fill in for the element corresponding to 4/6.

    4/1/2013
    5

    4/2/2013
    12

    4/3/2013
    11

    4/4/2013
    6

    4/5/2013
    7

    4/6/2013
    30

    4/7/2013
    21

    4/8/2013
    2

    4/1/2013
    3

    4/2/2013
    8

    4/3/2013
    9

    4/4/2013
    10

    4/5/2013
    1

    4/7/2013
    14

    4/8/2013
    12

    DB:3.59:Multiplying Data Between Query Tables With Missing Valuesdifferent Sizes cz

    One way would be to create a separate 2-column range which contains the 8 dates in column 1, an

    =IFERROR(VLOOKUP(A2,FirstQueryTable,2,False),0)*IFERROR(VLOOKUP(A2,SecondQueryTable,2,False),0)

    in column 2.

    Then you can load your array from the second column of this range.

  • RELEVANCY SCORE 3.26

    DB:3.26:500 Internal Server Error For Sap Pi System jx



    500 internal server error for sap pi system

    DB:3.26:500 Internal Server Error For Sap Pi System jx


    Hi Ravi,

    Please share your PI release and SP details.

    Also, complete description of your scenario and error log showing this message.

    This might be due to PI system HTTP service is down. Ask your basis team to check the tablespace and increase if it is low.

  • RELEVANCY SCORE 3.25

    DB:3.25:Pi / Xi And Jms Compliance 38



    Is PI/XI JMS compliant? Can one replace Sonic JMS provider functionality with PI ?

    DB:3.25:Pi / Xi And Jms Compliance 38


    Michael,

    Thanks for your response. Can you please advise me on the scenario below?

    In our IT organization we have both XI/PI and Sonic-Weblogic implementations.

    Sonic- Weblogic:

    We have deployed 20+ enterprise archive (EAR) files in Weblogic. Weblogic is configured to use Sonic. In each EAR file, as you can imagine we have message driven beans that intercept the messages published to Sonic Queues and topics. We have over 100 topics and queues in Sonic and Weblogic.

    We would like to consolidate to one Integration system, namely PI.

    Is it possible or advisable to move these message bus functionality into PI? Is there an Industry standard that we can follow and adhere to?

  • RELEVANCY SCORE 3.20

    DB:3.20:Pi 7.0 Information c9



    Hello!

    Is there a documentation or relase notes for PI 7.0 available?

    Where could I find features desciption of PI 7.0?

    DB:3.20:Pi 7.0 Information c9


    Hi Sergey,

    http://help.sap.com/saphelp_nw2004s/helpdata/en/43/fb4cd3207c7063e10000000a1553f6/frameset.htm

    Regards,

    Chandra

  • RELEVANCY SCORE 3.05

    DB:3.05:Cs4: Using Custom Data Links f1



    Hi all!

    I've created my own database based datalinks using Adobe custom datalink example. It uses URI to get data stream from database.

    There are several things I don't know how to do:

    1. How to apply my link to image or text items? I can't use Adobe example because it uses kImportAndLoadPlaceGunCmdBoss and loads data from file but my datalink loads data from database. I found IDataLinkHelper::AddDataLink method but I didn't find any example with it so I'm not sure how to use it correctly.

    2. How to remove my datalink? There is IDataLinkHelper::RemoveDataLink method but there are not any examples with it too.

    Thanks in advance.

    DB:3.05:Cs4: Using Custom Data Links f1


    I found that InDesign import InCopy file as snippet while placing it.

    Does anybody know how to use snippets with custom data link?

  • RELEVANCY SCORE 3.05

    DB:3.05:R3 Application Server Install ks



    Dear All

    we have installed new sap R3 CI-DB sever at VMware server.

    My VMware windows 2000 server host name is XXXXXXA, also addtionally my server has Datalink hostname with Different IP.

    fxWAM Hostname: XXXXXXXXA
    IP : xxx.xx.xx.xx
    Datalink:Hostname : XXXXXXXXXXB
    IP : xxx.xx.xx.xx

  • RELEVANCY SCORE 2.89

    DB:2.89:Adafruit Prototyping Pi Plate Kit For Raspberry Pi - p7



    hello,

    from Adafruit new Prototyping Pi Plate Kit for Raspberry Pi

    http://goo.gl/7o24l

    DB:2.89:Adafruit Prototyping Pi Plate Kit For Raspberry Pi - p7


    hello,

    from Adafruit new Prototyping Pi Plate Kit for Raspberry Pi

    http://goo.gl/7o24l

  • RELEVANCY SCORE 2.82

    DB:2.82:Dsl Technology zj



    Hi everybody.

    How is everyone doing ?

    Let say we have following set up.

    Home-lan---ethernet--DSLmodem1------------------ Telco(isp)

    What datalink layer protocol is used between dslmodem1 at customer's site and Telco(isp?

    Based on the following link it appears there could be several datalink protocol can be used

    http://en.wikipedia.org/wiki/PPPoE

    thanks and have a great weekend.

    DB:2.82:Dsl Technology zj


    Refer to this link...

    http://en.wikipedia.org/wiki/Digital_subscriber_line

    hth

    MS

  • RELEVANCY SCORE 2.82

    DB:2.82:Transport Tpz Files From Pi 7.1 Development Sytem To Pi 7.0 Production Sys cp



    Dear friends,

    We are in the process of PI 7.1 upgrade. Our Dev system is now in PI 7.1.

    Our production system in PI 7.0,Is there any way to transport tpz files from pi 7.1( Dev) to pi 7.0?(prod)

    Renu

    DB:2.82:Transport Tpz Files From Pi 7.1 Development Sytem To Pi 7.0 Production Sys cp

    transport tpz files from pi 7.1( Dev) to pi 7.0?(prod)

    Apart from what Abhishek said, why you want to transport objects from an upgraded Dev server to an existing Prod server and that also to a lower version?

  • RELEVANCY SCORE 2.82

    DB:2.82:Materialized View 9k


    Thanks Anupama
    Datalink is created successfully. But when i am selecting
    the table select * from tablename@datalinkname it show
    Credential Failed

    Lakshmi Narayanan

    DB:2.82:Materialized View 9k

    Can you post the exact error you're getting (including the error number)?

    Justin
    Distributed Database Consulting, Inc.
    http://www.ddbcinc.com/askDDBC

  • RELEVANCY SCORE 2.82

    DB:2.82:Linkloop Command j9


    Hello, all. Do you knwo if there is a command on Solaris equivalent to linkloop command on HP-UX.
    Linkloop commad tests connectivity between hosts on Datalink layer, using Mac address.

    DB:2.82:Linkloop Command j9

    Hello again. If there isn't , are there any alternative way to test connectivity on DataLink Layer on Solaris?
    I have two Solaris and one HP-UX. We sometimes can not access to HP-UX from remote machine so I'd like to check the above. Any advice appreciated. Thank you.

  • RELEVANCY SCORE 2.82

    DB:2.82:Download Map In Pi 7.0 73



    Can we download a mapping in PI 7.0 to XIM format?

    DB:2.82:Download Map In Pi 7.0 73


    Did you ever try clicking on the "text Preview" button (the one that has an eye glasses on a document icon)? It pretty much gives the same output as the PI Documenter, in fact better. I believe this is available in 7.0 too..!!

    VJ

  • RELEVANCY SCORE 2.82

    DB:2.82:Pi Symbol s9


    Where can I find a pi symbol?

    DB:2.82:Pi Symbol s9

    On the keyboard (US and Canadian English), option-p will give you , shift-option-P will give you (upper case greek PI).You can use Keyboard Viewer to see what characters are produced whin the option key is used as a modifier key.Regards,Barry

  • RELEVANCY SCORE 2.80

    DB:2.80:How To Add Views From Another Database To The Entity Framework Model? x7


    Is it possible to add a view from another database using datalink to the model? For example, my_view@db2.

    Thanks.

    Andy

    DB:2.80:How To Add Views From Another Database To The Entity Framework Model? x7

    Is it possible to add a view from another database using datalink to the model? For example, my_view@db2.

    Thanks.

    Andy

  • RELEVANCY SCORE 2.72

    DB:2.72:Pi cd



    hi why SAP-XI is called as PI

    DB:2.72:Pi cd


    Hi,

    as there is another product that SAP aquired (from business objects)

    called XI - so SAP had to change the name

    Regards,

    Michal Krawczyk

  • RELEVANCY SCORE 2.72

    DB:2.72:How To Work With Datalink d1


    hi.
    I have created a datalink and it is working from sqlplus. but from forms 6i it does not work . My code is

    Cursor c1 is select b.NAM_CUST_FULL,b.TXT_CUST_SEX,ltrim(rtrim(TXT_CUSTADR_ADD1)) ||chr(32)||ltrim(rtrim(TXT_CUSTADR_ADD2))||chr(32)||ltrim(rtrim(TXT_CUSTADR_ADD3))||chr(32)||ltrim(rtrim(NAM_CUSTADR_CITY)) address,REF_CUST_PHONE, REF_CUST_PHONE_OFF,REF_CUST_FAX,REF_CUST_EMAIL
    from CH_ACCT_MAST@fcrtest a, CI_CUSTMAST@fcrtest b
    where a. COD_CUST = b.COD_CUST_ID and
    a.COD_ACCT_NO=:CTL.ACC_NO;

    It is working form sqlplus but when i want to compile from forms 6i suddently form builder shutdown abnormally without giving any error. but frm lov it is working properly.
    What to do?

    Arif.

    DB:2.72:How To Work With Datalink d1

    hi.
    I have created a datalink and it is working from sqlplus. but from forms 6i it does not work . My code is

    Cursor c1 is select b.NAM_CUST_FULL,b.TXT_CUST_SEX,ltrim(rtrim(TXT_CUSTADR_ADD1)) ||chr(32)||ltrim(rtrim(TXT_CUSTADR_ADD2))||chr(32)||ltrim(rtrim(TXT_CUSTADR_ADD3))||chr(32)||ltrim(rtrim(NAM_CUSTADR_CITY)) address,REF_CUST_PHONE, REF_CUST_PHONE_OFF,REF_CUST_FAX,REF_CUST_EMAIL
    from CH_ACCT_MAST@fcrtest a, CI_CUSTMAST@fcrtest b
    where a. COD_CUST = b.COD_CUST_ID and
    a.COD_ACCT_NO=:CTL.ACC_NO;

    It is working form sqlplus but when i want to compile from forms 6i suddently form builder shutdown abnormally without giving any error. but frm lov it is working properly.
    What to do?

    Arif.

  • RELEVANCY SCORE 2.72

    DB:2.72:Pi Controller k7



    Hi;

    Can anybody tell me how to implement PI controller with picoblaze? And to implement the given equation in the PI controller using Picoblaze?

    Regards:

    Muhammad Danish

    DB:2.72:Pi Controller k7


    Hi Muhammad,

    it's done the same way like you would do it with any other microcontroller.

    (Be honest, what answer did you expect for such a generic question?)

    Maybe you should do some reading on numeric algorithms for control circuits.

    Also knowledge about (time) discrete implementation of PID-controllers and quantisation effects will be helpful.

    After that you write your assembler code (PSM-file), Assemble it with KCPSM3.exe and add the resulting file to your project.

    Have a nice synthesis

    Eilert

  • RELEVANCY SCORE 2.72

    DB:2.72:Does Pi Supports Vmware Esxi 5.1 Freeware Version? dc



    Does PI Supports VMware ESXi 5.1 freeware version?

    DB:2.72:Does Pi Supports Vmware Esxi 5.1 Freeware Version? dc


    ESXi freeware version” as it’s all the  same hypervisor software.  VMware ESXi, the software will work with full  functionality for 60 days. After 60 days, the admin needs to add a license, or  the system will be limited to a maximum of 32 Gig of RAM for the server.  Advanced features will also be disabled (DRS, vMotion), but these are not  required for PI. Using a “free” ESXi is very popular by many customers and  account teams, especially for Prime products. It allows a customer to purchase a  low cost UCS with 24 gig of RAM, install VMware ESXi for free and then add Prime  virtual appliances. This way the customer can use one physical server as a low  cost PI/ LMS appliance, where both run on the same hardware with no OS  cost.

  • RELEVANCY SCORE 2.72

    DB:2.72:Is Pi 7.X1 Another Way Of Saying Pi 7.X Ehp1? 19



    Hi All,

    Quick question.

    Is PI 7.01 another way of saying PI 7.0 EHP1?

    And if so, I presume that PI 7.11 is PI 7.1 EHP1, and that PI 7.31 is PI 7.3 EHP1.

    I ask, because I see documentation that show both forms.

    Many Thanks,

    Gareth

    DB:2.72:Is Pi 7.X1 Another Way Of Saying Pi 7.X Ehp1? 19


    Correct.

    Additional info.. lets say you have PI 7.11 Its PI Version 7.1 EHP1 and it can have different support packs.

    If you want see all details of 7.31 support packs, below is the link.

    Process Integration - What's New in SAP NetWeaver 7.3 EHP1 (Release Notes) - SAP Library

    Thanks Regards,

    A.Neelima.

  • RELEVANCY SCORE 2.72

    DB:2.72:Custom Datalink Implementation Problem a3


    Hi,

    I've been implementing a custom datalink trying to understand the CustomDataLink sample , but having some trouble right now with an assertion message:

    '::GetClass() - object is nil!'
    c:\Development\cobalt\source\public\components\publiclib\utils\PersistUtils.cpp (107)

    when invoking the panel menu in the Links tab with my custon datalink selected. Same error occurs when trying to access the context menu (right mouse button) on the custon datalink.

    This is the relevant interfaces on my boss class:

    Class
    {
    kMyCustomDataLinkBoss,
    kDataLinkBoss,
    {
    /** Implements custom IDataLink. */
    IID_IDATALINK, kMyCustomDataLinkImpl,
    /** Implements custom IDataLinkAction. */
    IID_IDATALINKACTION, kMyCustomDataLinkActionImpl,
    }
    },

    The IDataLink implementation is implemented with a persistent interface.
    Any hint on what I am missing? At the moment I am not sure what I should be checking.

    many thanks,

    Andrea

    DB:2.72:Custom Datalink Implementation Problem a3

    Yes, my link appears in the links panel fine. It's just when I try to access the panel menu with the link selected that the assertion mentioned above appears.
    Maybe it's harmless and I'm worrying too much, since so far apart from that everything seems to be working, I just want to be on the safe side there.

    Regards,

    Andrea

  • RELEVANCY SCORE 2.72

    DB:2.72:Need Blogs About Pi Monitoring xa



    Experts:

    Would you please provide some blogs on monitoring PI ?

    Thanks!!

    DB:2.72:Need Blogs About Pi Monitoring xa


    '

    Hi Search in SDN YOU Wl FIND TONS OF DOCUMENTS,

    refer below links too

    http://dlymper.blogspot.com/2009/01/sap-xi-component-monitoring-x-30.html

    http://xigenie.com/xi-functionality/rwb/67-xi-monitoring-and-error-handling

    REGARDS,

    rAJ

  • RELEVANCY SCORE 2.72

    DB:2.72:Isa Client Starting Excel With Third Party Add-In Is Slow sc


    The Excel Add-in is from OSISoft called PI Datalink. The PI Datalink does make connections to servers that collect Historian data. The Historian application is developed by OSISoft.
    OSISoft has recommended we upgrade our ISA client as a newer release fixed another customer's issue, but our ISA release we are running is much newer than their customer. Does anyone have any insight into what might be the issue between this Add-in and ISA?
    XP SP3
    EXCEL 2003 WITH PI ADD-IN
    load excel 2003 by itself - 5 seconds
    save blank workbook
    end excel process
    open blank workbook - 30 seconds

    XP SP3
    EXCEL 2003 NO ADD-IN
    load excel 2003 by itself - 5 seconds
    save blank workbook
    end excel process
    open blank workbook - 5 seconds
    Disabling ISA client on the XP machine allievates this slow down.
    They have suggested that we disable Excel from ISA.
    Microsoft's ISA proxy client should have an application.ini file in
    \Documents and Settings\user_name\Local Settings\Application
    Data\Microsoft\Firewall_client_folder

    Find the file and add the following two lines to disable the proxy
    client for excel:

    [Excel]
    Disable=1

  • RELEVANCY SCORE 2.72

    DB:2.72:Re: Datalink da


    check TNSNAMES.ORA file whether the identifier is there or not.

    DB:2.72:Re: Datalink da

    yes the identifier is there and working fine

  • RELEVANCY SCORE 2.72

    DB:2.72:How To Change Connection String Property In Datalink Tab With Database Options At Runtime? x3



    Hello

    please help me with your suggestions on the subject.

    I need to set "connection String" property at runtime as a result of some operation so as to log data in one of the 2 different database available.

    Regards

    Nitin Goel

    DB:2.72:How To Change Connection String Property In Datalink Tab With Database Options At Runtime? x3


    Hello Goel,

    are you thinking about something like this:

    Message Edited by frankne on 07-15-2009 01:40 AM

  • RELEVANCY SCORE 2.71

    DB:2.71:Designing Pi Controller d1


    Hello all,How can I design a PI controller in LabView? Any examplesThanks

  • RELEVANCY SCORE 2.71

    DB:2.71:The Required Active Directory Structure Was Not Created cz


    Hi I performed test SBS 2011 migration from SBS 2008. The only error after migration was:
    The required AD structure was not created.
    Here is just the part from SBS log , and if you need whole log just say.
    ----------------------------------------------------------
    [3200] 110708.162432.7693: Admin: Adding CN=Standard User to Domain Users
    [3200] 110708.162432.7762: Admin: Adding CN=Standard User to Windows SBS Remote Web Access Users
    [3200] 110708.162432.8084: Task: In Task TaskSetupAdminTemplates:
    [3200] 110708.162432.8084: Setup: Task TaskSetupAdminTemplates succeeded.
    [3200] 110708.162432.8446: Task: In Task TaskSetupAdminTemplates:
    [3200] 110708.162432.8446: Setup: Task TaskSetupAdminTemplates succeeded.
    [3200] 110708.162432.8485: Task: Stamping CN=Standard User as SbsUser
    [3200] 110708.162432.8485: Task: In Task TaskSetupAdminTemplates:
    [3200] 110708.162432.8485: Setup: Task TaskSetupAdminTemplates succeeded.
    [3200] 110708.162432.8905: Task: In Task TaskSetupAdminTemplates:
    [3200] 110708.162432.8905: Setup: Task TaskSetupAdminTemplates succeeded.
    [3200] 110708.162432.8992: Task: In Task TaskSetupAdminTemplates:
    [3200] 110708.162432.8992: Setup: Task TaskSetupAdminTemplates succeeded.
    [3200] 110708.162432.9071: Task: In Task TaskSetupAdminTemplates:
    [3200] 110708.162432.9071: Setup: Task TaskSetupAdminTemplates succeeded.
    [3200] 110708.162432.9090: Task: In Task TaskSetupAdminTemplates:
    [3200] 110708.162432.9090: Setup: Task TaskSetupAdminTemplates succeeded.
    [3200] 110708.162432.9100: Task: User Role created.
    [3200] 110708.162432.9911: Admin: Adding CN=Network Administrator to Windows SBS Remote Web Access Users
    [3200] 110708.162433.0233: Task: In Task TaskSetupAdminTemplates:
    [3200] 110708.162433.0233: Setup: Task TaskSetupAdminTemplates succeeded.
    [3200] 110708.162433.1044: Exception:
    ---------------------------------------
    An exception of type 'Type: System.DirectoryServices.DirectoryServicesCOMException, System.DirectoryServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' has occurred.
    Timestamp: 07/08/2011 16:24:33
    Message: The object already exists.

    Stack: at System.DirectoryServices.DirectoryEntry.CommitChanges()
    at Microsoft.WindowsServerSolutions.Admin.Common.TaskSetRoleADProperties.RunADOperation(ITaskDataLink dataLink)
    at Microsoft.WindowsServerSolutions.Admin.Common.ADTask.RunADOperationWrapper(ITaskDataLink dataLink)
    at Microsoft.WindowsServerSolutions.Admin.Common.AD.RunADOperation[T,R](ADOperation`2 op, T parameter)

    [3200] 110708.162433.1424: Task: An exception was in TaskSetupAdminTemplates: Task: TaskSetRoleADProperties failed: Microsoft.WindowsServerSolutions.TaskManagement.Admin.TaskExecutionException: Windows SBS --- System.DirectoryServices.DirectoryServicesCOMException:
    The object already exists.

    at System.DirectoryServices.DirectoryEntry.CommitChanges()
    at Microsoft.WindowsServerSolutions.Admin.Common.TaskSetRoleADProperties.RunADOperation(ITaskDataLink dataLink)
    at Microsoft.WindowsServerSolutions.Admin.Common.ADTask.RunADOperationWrapper(ITaskDataLink dataLink)
    at Microsoft.WindowsServerSolutions.Admin.Common.AD.RunADOperation[T,R](ADOperation`2 op, T parameter)
    --- End of inner exception stack trace ---
    at Microsoft.WindowsServerSolutions.Admin.Common.AD.RunADOperation[T,R](ADOperation`2 op, T parameter)
    at Microsoft.WindowsServerSolutions.TaskManagement.Admin.LightweightDataLink.Run(TaskId taskId, IAssemblyTask task, CompositeTask parentTask)
    at Microsoft.WindowsServerSolutions.TaskManagement.Admin.SequentialTask.Run(ITaskDataLink dataLink)
    at Microsoft.WindowsServerSolutions.TaskManagement.Admin.LightweightDataLink.Run(TaskId taskId, IAssemblyTask task, CompositeTask parentTask)
    at Microsoft.WindowsServerSolutions.TaskManagement.Admin.SequentialTask.Run(ITaskDataLink dataLink)
    at Microsoft.WindowsServerSolutions.Admin.Common.TaskCreateRole.Run(ITaskDataLink dataLink)
    at Microsoft.WindowsServerSolutions.Admin.Common.TaskSetupAdminTemplates.Run(ITaskDataLink dataLink)
    [3200] 110708.162433.1434: Task: In Task TaskSetupAdminTemplates: The required Active Directory structure was not created.
    [3200] 110708.162433.1434: Setup: Task TaskSetupAdminTemplates failed.
    [3200] 110708.162433.1434: Task: Task (TaskSetupAdminTemplates) execution complete.

    DB:2.71:The Required Active Directory Structure Was Not Created cz

    Since Network Admin existed as a user on SBS 2008 , I had this error. Once i deleted this user, thanks to this article,https://msmvps.com/blogs/sbsdiva/archive/2011/01/20/for-the-record-don-t-use-networkadmin.aspx
    setup was performed without any error.
    Thanks

  • RELEVANCY SCORE 2.71

    DB:2.71:Pi 2004_1_470 c7



    dear all;

    how to upgrade packege from PI 2002_1_470 to PI 2004_1_470

    regards

    DB:2.71:Pi 2004_1_470 c7


    you have to patch PI 2002_1_470 to a required pathc level and then thru SAINT do a delta upgrade. This brings it to PI 2004_1_470

  • RELEVANCY SCORE 2.71

    DB:2.71:Access Remote Db In Function cm


    --
    When I tried to create a function which references a remote DB
    thr. DataLink, it errored out with messages like 'error occurred
    when looking up remote object ...'.

    How to restrict the function to modify the remote database like
    PRAGAMA RESTRICT_REFERENCES (FunctionName, WNDS) does for local
    DB?

    thanx,

    Chris
    null

    DB:2.71:Access Remote Db In Function cm

    --
    When I tried to create a function which references a remote DB
    thr. DataLink, it errored out with messages like 'error occurred
    when looking up remote object ...'.

    How to restrict the function to modify the remote database like
    PRAGAMA RESTRICT_REFERENCES (FunctionName, WNDS) does for local
    DB?

    thanx,

    Chris
    null

  • RELEVANCY SCORE 2.66

    DB:2.66:Materialized View ms


    I have create a DataLink it was successfully created.

    I give a select statement like

    select * from table name from
    table name@DataLink Name;

    Can anyone help on this

    DB:2.66:Materialized View ms

    Thanks Anupama.

    I have created datalink Sucessfully. Only i got an error
    select * from tablename@datalinkname;

    Credential Failed

    Lakshmi Narayanan

  • RELEVANCY SCORE 2.65

    DB:2.65:Tcode For Pi Interfaces 1m


    Hello All,Is ther any tcode in PI to get list of all interfaces built in PI ? Thanks you

    DB:2.65:Tcode For Pi Interfaces 1m

    Hi,Check this table SMPPREL3 in SE16. I think this will give you all the interface details that you are looking for.Regards,Francis

  • RELEVANCY SCORE 2.64

    DB:2.64:Link To Get Data From Oracle9i Spatial fp


    Hi estimated friends

    In this moment I am carrying out some tests of functionality with Maps created in MapInfo to load them into Oracle9i Spatial.

    I have loaded data to Oracle from MapInfo without any trouble, when I do it the EasyLoader create a .tab file which inside has a link to retrieve data from Oracle. When I try to open that file I am getting an error. I guess the error is coming because in the file lacks the password of the schema to be queried.

    The following file is the file created:

    !table
    !version 500
    !charset WindowsLatin1

    Definition Table
    Type ODBC
    begin_metadata
    "\IsReadOnly" = "FALSE"
    "\DATALINK" = ""
    "\DATALINK\Query" = "select * from ""SCOTT"".""TEST5"""
    "\DATALINK\ConnectionString" = "SRVR=SIGEP2;UID=SCOTT"
    "\DATALINK\ToolKit" = "ORAINET"
    "\CACHE" = "ON"
    "\MBRSEARCH" = "ON"
    end_metadataHave you had this problem ? and if the asnwer is yes, how did you fix it ?

    Thanks in advance

    Joel Prez

    DB:2.64:Link To Get Data From Oracle9i Spatial fp

    Hi estimated friends

    In this moment I am carrying out some tests of functionality with Maps created in MapInfo to load them into Oracle9i Spatial.

    I have loaded data to Oracle from MapInfo without any trouble, when I do it the EasyLoader create a .tab file which inside has a link to retrieve data from Oracle. When I try to open that file I am getting an error. I guess the error is coming because in the file lacks the password of the schema to be queried.

    The following file is the file created:

    !table
    !version 500
    !charset WindowsLatin1

    Definition Table
    Type ODBC
    begin_metadata
    "\IsReadOnly" = "FALSE"
    "\DATALINK" = ""
    "\DATALINK\Query" = "select * from ""SCOTT"".""TEST5"""
    "\DATALINK\ConnectionString" = "SRVR=SIGEP2;UID=SCOTT"
    "\DATALINK\ToolKit" = "ORAINET"
    "\CACHE" = "ON"
    "\MBRSEARCH" = "ON"
    end_metadataHave you had this problem ? and if the asnwer is yes, how did you fix it ?

    Thanks in advance

    Joel Prez

  • RELEVANCY SCORE 2.64

    DB:2.64:Pi 7.1 In Discovery System cd



    Just wondering what the PI upgrade path will be for the discovery system when PI 7.1 is released?

    DB:2.64:Pi 7.1 In Discovery System cd


    Thanks thats what i was wondering, if it will be possible to upgrade the PI component of the Discovery System.

  • RELEVANCY SCORE 2.63

    DB:2.63:Arp 9c



    I have read in a book that ARP and RARP work on the top of datalink layer.Actually where do these two protocols work ,in the Network layer or the datalink layer ?

    DB:2.63:Arp 9c


    ARP is often considered to work "in between" Ethernet and IP, at layer 2.5 if you will. That's probably what the author means. Though since it does run on top of Ethernet, it can also be considered layer 3.

    When you get more and more involved in this stuff it becomes clearer that the OSI layers aren't something to be taken too too seriously -- they can help from a conceptual level, but that's about it. A lot of protocols don't exactly fit into one layer or another. Consider ICMP, for example. It runs over IP, but no one ever calls it a layer 4 protocol. It's generally considered layer 3.5.

  • RELEVANCY SCORE 2.61

    DB:2.61:Re: Datalink From Excel Table Text Issue! c7



    Please see attached PDF. This is Data Link from excel. I tried to change text size but itno luck, except if I change the text note. Any i dea from the expert here? Thanks!










    Attachments:







    Table Text.pdf ‏248 KB

    DB:2.61:Re: Datalink From Excel Table Text Issue! c7


    I used your excel file and it cameout fine then revised my excel file comparing with yours (changing headers to General from Custom) then save it and everythingare the same, still the problem is there. So, I suspect something wrong with my system.Well, thanks to your response anyway, I appreciate that.

  • RELEVANCY SCORE 2.61

    DB:2.61:User Roles 8m



    Hi,

    Wanted to know standard SAP roles in PI 7.1 for :

    1) PI Developer

    2) PI Admin

    Thank you.

    DB:2.61:User Roles 8m


    Hi,

    Please see this url where you can see all the roles:

    http://www.erpgenie.com/sap/netweaver/xi/xiauthorizations.htm

    Regards,

    ---Satish

  • RELEVANCY SCORE 2.61

    DB:2.61:Dirapi Pi 7.11 To Pi 7.31 p1



    Will the PI 7.11 dirapi code work with PI7.31. I am planning to use the existing PI 7.11 dirapi code to migrate the communication channels to PI 7.31.

    DB:2.61:Dirapi Pi 7.11 To Pi 7.31 p1


    Thanks Vadim. This is good information.

    However we are planning to move to PI 7.31 dual stack. I am assuming this tool will work in my case as well.

    Pls advice.

  • RELEVANCY SCORE 2.60

    DB:2.60:Multiple Databases, Same Machine, Datalink d3


    Good night Oracle community,I have a simple question I couldn't find the answer (at least easily). When having multiple databases on the same machine who communicates through datalink, does network issues can be related to slow performance?Thank you very much!

    DB:2.60:Multiple Databases, Same Machine, Datalink d3

    You mean database link under datalink, right?If yes I think most likely not the database link is your performance issue. But we would need much more information to be sure.E.g. execution plan

  • RELEVANCY SCORE 2.60

    DB:2.60:Proxy Regeneration In Pi 7.1 js



    Why do we regenerate the proxies after ugradation of system from XI or PI 7.0 to PI 7.1?

    DB:2.60:Proxy Regeneration In Pi 7.1 js


    Why do we regenerate the proxies after ugradation of system from XI or PI 7.0 to PI 7.1?

    We regenerate ABAP proxies only when we do some changes in XI Data Type (eithere change in field name or structure level changes) otherwise upgrading your XI system to PI7.1 will not require any proxy regeneration.

  • RELEVANCY SCORE 2.60

    DB:2.60:Raspberry Pi + Opo? 3c


    Hey,
    is it possible to use the raspberry pi with the OPO as a computer?

    DB:2.60:Raspberry Pi + Opo? 3c

    Yeah but which Opie?

    Raspi Model A =

    Raspi 2 =

  • RELEVANCY SCORE 2.60

    DB:2.60:Windows Apis For Accessing Network And Datalink Layer Primitives s8


    Are there windows APIs for accessing network and data link layer primitives?

    DB:2.60:Windows Apis For Accessing Network And Datalink Layer Primitives s8

    you could try in this forum
    http://social.msdn.microsoft.com/Forums/en-US/peertopeer/threads
    or search MSDN
    http://msdn.microsoft.com/en-us/library/ee663286(v=VS.85).aspx

  • RELEVANCY SCORE 2.60

    DB:2.60:Using A Datalink With Sequence jk


    Hello all!

    I'm trying to use a sequence from a differnet database by using a datalink. I know my sequence works as well as my datalink. However, my stored procedure won't compile because of this statement.

    select cahistoryid.nextval into v_nNewCAHistoryID from dual@ht1.world;

    The error message states. "Identifier 'cahistory.nextval' must be declared"

    Is there another way to do this or can it not be accomplished?

    Any help would be great!!

    TIA

    Brian

    DB:2.60:Using A Datalink With Sequence jk

    Hey thanks Todd!! Worked like a charm! I've only been developing in PL/SQL for 6 months and figuring out stuff like this through books w/o alot of content can be frustrating!

    Thanks again!

    Brian

  • RELEVANCY SCORE 2.60

    DB:2.60:How To Use Multiple Isp Connection To 5510 cm



    Dear all!i've two cisco asa5510 with 4 FastEthernet interfaces each.They are connected as below:

    Firewall01                                                                                         Firewall02

    Fa0/0 - ISP1 (offer VPN Services to Public IP address)                  Fa0/0 - ISP2 (offer VPN Services to Public IP address)

    Fa0/1 - Lan connection                                                                     Fa0/1 - Lan Connection

    Fa0/2 - DataLink to Customer01                                                      Fa0/2 - DataLink to customer02

    Fa0/3 - Datalink to customer03                                                        Fa0/3 - Datalink to Customer04

    to three different ISP each of them! The 4rth interface of each of them, is connected to internal LAN network. Both Firewalls, offers VPN Services to ISP connections on Fa0/0

    How can i achieve high availability for this scneario?

    is this possible to implement some HighAvailability and to offer the actual services to each of them, in case that the other firewall fail?

    What about using subintefaces? can i connect bothe ISP and Customers links on one or each of them, in case that firewall01 fails, all the services to be online on firewall02?

    What about if i use virtual contexts? in this case, i'll lose VPN services, right?Please, give me your suggestions!

    Regards!

    DB:2.60:How To Use Multiple Isp Connection To 5510 cm


    Versions after 9.0 all support VPN when running in multiple context.

    This way you can have a context for each client and communicate the contexts using the "cascading" concept

    Will also let you run the ASAs in failover and achieve redundancy.

  • RELEVANCY SCORE 2.60

    DB:2.60:Pi? p7


    Is there a character in JAVA that is used for pi, or a word. that has an approximate value of pi?

    DB:2.60:Pi? p7

    double #960; = Math.PI;

  • RELEVANCY SCORE 2.60

    DB:2.60:Runtime Changes In Pi 7.1 7m



    Hi, i am looking for specific runtime changes in PI 7.1 or is the runtime of PI 7.0 and PI 7.1 exctly the same.

    DB:2.60:Runtime Changes In Pi 7.1 7m


    Hi Roy,

    Runtime Enhancements:

    Delivery Mode

    Governs the delivery of messages to receive steps to running process instances.

    The parameter can take two values u201CWith Bufferingu201D and u201CWithout Bufferingu201D

    Setting with Buffering

    Additional storage of messages: If message to be delivered to running process cannot be taken up by a receive step, it is buffered.

    The following receive step will take up buffered message

    Drawback: If no further receive step is available, the message is captured by the process and might get lost

    Setting without Buffering

    Message is delivered directly to waiting receive step

    Developer has to guarantee that for each delivered message there will be an open receive step

    Drawback: If instance does not provide an open receive step, the process type specific queue (XBQO$PE_WS...) goes to status u201CSYSFAILu201D.

    1) Defines whether messages are handed over to process instance directly or with intermediate buffering

    2) Queue Assignment

    It defines whether messages are handed over to process instance using single or multiple queues.

    Permits a parallelization of process execution.

    Multiple queues may either use, Arbitrary distribution to queues (and hence process instances). Mainly used for split processes.

    Or

    Content-based distribution (required for all process types using correlations). Mainly used for collect processes.

    3) Transaction Handling

    So far:

    Pessimistic assumption regarding transactional behavior

    Required numerous creation of work items and execution DB actions

    Now:

    Developer decides whether

    A step creates new transaction

    Or

    The steps are executed synchronously

    Configurable DB sync points

    4) BPE Message Bulking

    Delivery of message bulks to BPE inbound processing to increase the message through put.

    Advantages

    Delivery of multiple messages to process instance in a single transaction

    Raises message throughput (but: latency of single message may increase)

    Reduces persistence effort

    Reduces occupied DB space

    Thanks,

    Satya Kumar

  • RELEVANCY SCORE 2.60

    DB:2.60:Datalink Layers And Broadcasts sk



    Hi all, is it possible to send broadcasts over other datalink types than ethernet ?

    DB:2.60:Datalink Layers And Broadcasts sk


    this not a feature that we turn on or off, but it is related to protocol itself. as i sai this possible for example with fr or x25.

    in other hand, you can use "ip helper-address" to forward some particular broadcasts such as dhcp request... to a particular server in remote site

    http://www.cisco.com/en/US/docs/ios/12_3t/ip_addr/command/reference/ip1_i1gt.html#wp1169356

  • RELEVANCY SCORE 2.60

    DB:2.60:Super Pi d7


    Where Can I download a copy of Super Pi of Tiger?

    DB:2.60:Super Pi d7

    Yes. You are correct, sir. That is exactly what I meant.

  • RELEVANCY SCORE 2.60

    DB:2.60:Code To Calculate Pi zs


    help me

    DB:2.60:Code To Calculate Pi zs

    Sun's RMI tutorials have a nice algorithm for exactly this. I'm way too
    tired to look up the URL though.

    kind regards,

    Jos

  • RELEVANCY SCORE 2.59

    DB:2.59:I Have Error During Datalink Connetion 99


     Unable to establish connection.please ensure that the connection  properties for datalink1 correct that the connection is available.ADO error: cannot start your application. The workbook information file is missing or open exclusively by another user.

    DB:2.59:I Have Error During Datalink Connetion 99

     Hi kaneniyou could try to copy that file to a temp location and open from another location. or would you want to open password protected Excel Workbook ?this is a article about How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NEThttp://support.microsoft.com/default.aspx?scid=kb;[LN];Q316934

     

     

     

    Imports System.Data.OleDb     

        

        

    'insert into From1.vb     

    Private m_sConn1 As String = Provider=Microsoft.Jet.OLEDB.4.0;  _     

                   Data Source=C:\ExcelData1.xls;  _     

                   Extended Properties=Excel 8.0;HDR=YES     

        

    Private m_sConn2 As String = Provider=Microsoft.Jet.OLEDB.4.0;  _     

                   Data Source=C:\ExcelData2.xls;  _     

                   Extended Properties=Excel 8.0;HDR=YES     

        

    Private m_sNorthwind = _     

          C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb     

        

    Private m_sAction As String     

        

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load     

          RadioButton1.Text = Create_Workbook    

          RadioButton2.Text = Retrieve_Records    

          RadioButton3.Text = Add_Records    

          RadioButton4.Text = Update_Records    

          RadioButton5.Text = Update_Individual_Cells    

          RadioButton6.Text = Use_External_Source    

          Button1.Text = Go!    

    End Sub     

        

    Private Sub RadioButtons_Click(ByVal sender As Object, ByVal e As System.EventArgs) _     

          Handles RadioButton1.Click, RadioButton2.Click, RadioButton3.Click, _     

          RadioButton4.Click, RadioButton5.Click, RadioButton6.Click     

          m_sAction = sender.Text'Store the text for the selected radio button     

    End Sub     

        

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click     

          Try     

             ' Call the associated routine to add/update/modify the workbook.     

             Select Case m_sAction     

                Case Create_Workbook : Create_Workbook()     

                Case Retrieve_Records : Retrieve_Records()     

                Case Add_Records : Add_Records()     

                Case Update_Records : Update_Records()     

                Case Update_Individual_Cells : Update_Individual_Cells()     

                Case Use_External_Source : Use_External_Source()     

             End Select     

        

          Catch ex As OleDbException     

             Dim er As OleDbError     

             For Each er In ex.Errors     

                MsgBox(er.Message)     

             Next     

          Catch ex2 As System.InvalidOperationException     

             MsgBox(ex2.Message)     

          End Try     

        

        

    End Sub     

        

    Public Sub Create_Workbook()     

        

          ' If the workbooks already exist, prompt to delete.     

          Dim answer As MsgBoxResult     

          If Dir(C:\ExcelData1.xls)   Or Dir(C:\ExcelData2.xls)   Then     

              answer = MsgBox(Delete existing workbooks (C:\ExcelData1.xls and   _     

                       C:\ExcelData2.xls)?, MsgBoxStyle.YesNo)     

              If answer = MsgBoxResult.Yes Then     

                  If Dir(C:\ExcelData1.xls)   Then Kill(C:\ExcelData1.xls)     

                  If Dir(C:\ExcelData2.xls)   Then Kill(C:\ExcelData2.xls)     

              Else     

                  Exit Sub     

              End If     

          End If     

        

    '==========================================================================     

          ' Create a workbook with a table named EmployeeData. The table has 3      

          ' fields: ID (char 255), Name (char 255) and Birthdate (date).       

    '==========================================================================     

          Dim conn As New OleDbConnection()     

          conn.ConnectionString = m_sConn1    

          conn.Open()     

          Dim cmd1 As New OleDbCommand()     

          cmd1.Connection = conn    

          cmd1.CommandText = CREATE TABLE EmployeeData (Id char(255), Name char(255), BirthDate date)    

          cmd1.ExecuteNonQuery()     

          cmd1.CommandText = INSERT INTO EmployeeData (Id, Name, BirthDate) values ('AAA', 'Andrew', '12/4/1955')    

          cmd1.ExecuteNonQuery()     

          conn.Close()     

        

    '==========================================================================     

          ' Create a workbook with a table named InventoryData. The table has 3      

          ' fields: Product (char 255), Qty (float) and Price (currency).      

    '==========================================================================     

        

          conn.ConnectionString = m_sConn2    

          conn.Open()     

          Dim cmd2 As New OleDbCommand()     

          cmd2.Connection = conn    

          cmd2.CommandText = CREATE TABLE InventoryData (Product char(255), Qty float, Price currency)    

          cmd2.ExecuteNonQuery()     

          cmd2.CommandText = INSERT INTO InventoryData (Product, Qty, Price) values ('Cola', 200, 1.35)    

          cmd2.ExecuteNonQuery()     

          cmd2.CommandText = INSERT INTO InventoryData (Product, Qty, Price) values ('Chips', 550, 0.89)    

          cmd2.ExecuteNonQuery()     

          conn.Close()     

        

          ' NOTE: You can ALTER and DROP tables in a similar fashion.     

        

    End Sub     

        

    Public Sub Retrieve_Records()     

        

          '==========================================================     

          'Use a DataReader to read data from the EmployeeData table.     

          '==========================================================     

        

          Dim conn1 As New System.Data.OleDb.OleDbConnection(m_sConn1)     

          conn1.Open()     

          Dim cmd1 As New System.Data.OleDb.OleDbCommand(Select * From [EmployeeData$], conn1)     

          Dim rdr As OleDbDataReader = cmd1.ExecuteReader     

        

          Debug.WriteLine(vbCrLf  EmployeeData:  vbCrLf  =============)     

          Do While rdr.Read()     

             Debug.WriteLine(System.String.Format({0,-10}{1, -15}{2}, _     

                rdr.GetString(0), rdr.GetString(1), _     

                rdr.GetDateTime(2).ToString(d)))     

          Loop     

          rdr.Close()     

          conn1.Close()     

        

          '========================================================     

          'Use a DataSet to read data from the InventoryData table.     

          '========================================================     

          Dim conn2 As New OleDbConnection(m_sConn2)     

          Dim da As New OleDbDataAdapter(Select * From [InventoryData$], conn2)     

          Dim ds As DataSet = New DataSet()     

          da.Fill(ds)     

          Debug.WriteLine(vbCrLf  InventoryData:  vbCrLf  ==============)     

          Dim dr As DataRow     

          For Each dr In ds.Tables(0).Rows'Show results in output window     

             Debug.WriteLine(System.String.Format({0,-15}{1, -6}{2}, _     

                dr(Product), dr(Qty), dr(Price)))     

          Next     

          conn2.Close()     

        

    End Sub     

        

    Public Sub Add_Records()     

        

    '==========================================================================     

          ' Run an INSERT INTO command to add new records to the workbook.      

    '==========================================================================     

          Dim conn1 As New System.Data.OleDb.OleDbConnection(m_sConn1)     

          conn1.Open()     

          Dim cmd As New System.Data.OleDb.OleDbCommand()     

          cmd.Connection = conn1    

          cmd.CommandText = INSERT INTO [EmployeeData$] (ID, Name, BirthDate) values ('CCC', 'Charlie', '10/14/48')    

          cmd.ExecuteNonQuery()     

          cmd.CommandText = INSERT INTO [EmployeeData$] (ID, Name, BirthDate) values ('DDD', 'Deloris', '7/19/98')    

          cmd.ExecuteNonQuery()     

          conn1.Close()     

        

          '====================================================================     

          'Use the InsertCommand object to add new records to the InventoryData     

          'table.     

          '====================================================================     

          Dim conn2 As New OleDbConnection(m_sConn2)     

          Dim da As New OleDbDataAdapter(Select * From [InventoryData$], conn2)     

          Dim ds As DataSet = New DataSet()     

          da.Fill(ds, MyExcelTable)     

        

          ' Generate the InsertCommand and add the parameters for the command.     

          da.InsertCommand = New OleDbCommand( _     

             INSERT INTO [InventoryData$] (Product, Qty, Price) VALUES (?, ?, ?), conn2)     

          da.InsertCommand.Parameters.Add(@Product, OleDbType.VarChar, 255, Product)     

          da.InsertCommand.Parameters.Add(@Qty, OleDbType.Double).SourceColumn = Qty    

          da.InsertCommand.Parameters.Add(@Price, OleDbType.Currency).SourceColumn = Price    

        

          ' Add two new records to the dataset.     

          Dim dr As DataRow     

          dr = ds.Tables(0).NewRow     

          dr(Product) = Bread : dr(Qty) = 390 : dr(Price) = 1.89 : ds.Tables(0).Rows.Add(dr)     

          dr = ds.Tables(0).NewRow     

          dr(Product) = Milk : dr(Qty) = 99 : dr(Price) = 2.59 : ds.Tables(0).Rows.Add(dr)     

        

          ' Apply the dataset changes to the actual data source (the workbook).     

          da.Update(ds, MyExcelTable)     

          conn2.Close()     

        

    End Sub     

        

    Public Sub Update_Records()     

        

    '==========================================================================     

          ' Run an UPDATE command to change a record in the EmployeeData     

          ' table.     

    '==========================================================================     

          Dim conn1 As New System.Data.OleDb.OleDbConnection(m_sConn1)     

          conn1.Open()     

          Dim cmd As New System.Data.OleDb.OleDbCommand()     

          cmd.Connection = conn1    

          cmd.CommandText = UPDATE [EmployeeData$]   _     

                        SET NAME = 'Aaron', BirthDate = '5/4/1975' WHERE ID = 'AAA'     

          cmd.ExecuteNonQuery()     

          conn1.Close()     

        

          '====================================================================     

          ' Use the UpdateCommand object to modify records in the InventoryData     

          ' table.     

          '====================================================================     

          Dim conn2 As New OleDbConnection(m_sConn2)     

          Dim da As New OleDbDataAdapter(Select * From [InventoryData$], conn2)     

          Dim ds As DataSet = New DataSet()     

          da.Fill(ds, MyInventoryTable)     

        

          ' Generate the UpdateCommand and add the parameters for the command.     

          da.UpdateCommand = New OleDbCommand( _     

             UPDATE [InventoryData$] SET Qty = ?, Price=? WHERE Product = ?, conn2)     

          da.UpdateCommand.Parameters.Add(@Qty, OleDbType.Numeric).SourceColumn = Qty    

          da.UpdateCommand.Parameters.Add(@Price, OleDbType.Currency).SourceColumn = Price    

          da.UpdateCommand.Parameters.Add(@Product, OleDbType.VarChar, 255, Product)     

        

          ' Update the first two records.     

          ds.Tables(0).Rows(0)(Qty) = 1000     

          ds.Tables(0).Rows(0)(Price) = 10.1     

          ds.Tables(0).Rows(1)(Qty) = 2000     

          ds.Tables(0).Rows(1)(Price) = 20.2     

        

          ' Apply the dataset changes to the actual data source (the workbook).     

          da.Update(ds, MyInventoryTable)     

          conn2.Close()     

        

    End Sub     

        

    Public Sub Update_Individual_Cells()      

     

  • RELEVANCY SCORE 2.59

    DB:2.59:Windows 7 Task Scheduler .Vbs Createobject(Excel.Application) Error:70 Permission Denied 1p


    I have a .vbs script that I'm trying to move from a Windows XP box to a Windows 7 box

    The script runs correctly manually, but fails when run from the Task Scheduler.

    Similarly, the script has always run correctly from the Windows XP Task Scheduler but fails in the Windows 7 Task Scheduler.

    I have isolated the Error to the following line of code:

    Set fileobj=CreateObject(Excel.Application)
    I output the err.number and err.description to a Log file and I get:

    Error:70 Permission denied

    Interestingly, other calls to the CreateObject function inside the same script work fine, including:

    Set fso = CreateObject(Scripting.FileSystemObject)
    Set app = CreateObject(SASEGObjectModel.Application.4.3)

    It's only the call to create the Excel object that fails.

    Does anyone know why this would fail in this way:
    Fails when run from the scheduler, but succeeds manually?
    Works on Windows XP but does not work in Windows 7?

    I found a similar issue here:
    http://social.msdn.microsoft.com/Forums/is/exceldev/thread/ac2549f5-fc1e-494d-9015-70cb31d3aeb2

    However, the solution looked like it was specific to the operating system Windows Server 2008 Rw 64-bit.
    Does anyone know a resolution that works on Windows 7?

    Note: The Windows 7 box has Office 2010 while the Windows XP box has Office 2007

    Sub OpenDRAInvRunMac (WorkBookStr)

    Dim fileobj
    Dim XLfile
    Dim appXL
    Dim strWorkBook
    Dim oAddin

    strWorkBook = WorkBookStr

    Set fileobj=CreateObject(Excel.Application)
    fileobj.Visible = False
    fileobj.WorkBooks.Open(strWorkBook)

    If (fileobj.addins(PI-Datalink).installed = True) Then
    fileobj.addins(PI-Datalink).installed = False
    End If
    fileobj.addins(PI-Datalink).installed = True

    fileobj.Run(DRAInvCopy)

    fileobj.DisplayAlerts = False
    fileobj.WorkBooks.close
    fileobj.DisplayAlerts = True
    fileobj.quit

    End Sub

    DB:2.59:Windows 7 Task Scheduler .Vbs Createobject(Excel.Application) Error:70 Permission Denied 1p

    sabado is right it's not supported, but there is a workaround.
    it worked for me so give it a try.

    Resolution

    ************

    A “Desktop” folder seems to be necessary in the “systemprofile” folder in the location C:\Windows\SysWOW64\config\ to open an Excel fileCreate the “Desktop” folder for Windows 2008 Server (x64) under the location C:\Windows\SysWOW64\config\systemprofileAnd for a 32 bit Windows 2008 Server create the “Desktop” folder under the location C:\Windows\System32\config\systemprofileAfter creating the folder the SQL Server jobs should execute successfully

    source
    blogs.msdn.com/b/sqlserverfaq/archive/2010/04/30/unable-to-open-excel-files-using-a-cscript-in-sql-server-jobs.aspx

  • RELEVANCY SCORE 2.59

    DB:2.59:Happy Pi Day! zd



    In honor of 3.14 here is plenty of Pi for everyone (or at least 10000 or so).










    Attachments:






    Pi Spigot.vi ‏15 KB

    DB:2.59:Happy Pi Day! zd

    I often do an initial sketch of the code with mostly diagram constants instead of controls. If you later turn them into controls, the default value will be whatever the value of the diagram constant was.



    LabVIEW Champion . Do more with less code and in less time .

  • RELEVANCY SCORE 2.59

    DB:2.59:Tt Operate's Help cz


    1.In TimesTen how to visit data between the different instances ,just like Oracle's datalink;
    2.In TimesTen how to operate without logging,for instance loading cache group ;

    DB:2.59:Tt Operate's Help cz

    1. TimesTen does not have any mecanism to allow for queries or transactions to span datastores, sorry. You will need to handle this in the application.

    2. To turn logging off you can set the ODBC paramater Logging to the value 0 (Logging=0). This parameter takes effect at the time the datastore is loaded into memory so to switch between logging and no logging mode you must unload/load the datastore from/to memory.

    Note that when in 'no logging' mode, functionality is very limited. There is no replication, very limited support for cache connect, no XLA, no transactions and very low concurrency (all locking is at database level). In most cases, you can achieve very good performance with logging turned on as long as you have a correct configuration and adequate hardware. I would consider carefully if you really need to use no logging mode.

    Chris

  • RELEVANCY SCORE 2.59

    DB:2.59:Outerjoin In Datalink ? s7


    Hello,
    I have a report which uses two queries joined in the data model by data links. I would like the queries to be joined like in a outerjoin. That is if there are no records in the detail query then also the rows should be returned. Please advise how I can do this.

    Thanks

    DB:2.59:Outerjoin In Datalink ? s7

    Thanks Ammad, I was thinking of the same but just wanted to check if there was another way out. Thanks for your response.

    Edited by: IQ on Mar 19, 2010 8:21 AM

  • RELEVANCY SCORE 2.59

    DB:2.59:Codec Bandwidth Calculaion 9m



    Hi!

    In Cvoice Studentguide Datalink overhead

    for Ethernet is 18 bytes

    for Frame-relay is 6 bytes

    However in Cisco IP telephony QOS design guide Datalink overhead

    for Ethernet is 14 bytes

    for Frame-relay is 4 bytes

    During Codec Bandwidth Calculaion which one should be considered?

    DB:2.59:Codec Bandwidth Calculaion 9m


    It depends on what you are using this for - link capacity or QoS settings ("priority" and "bandwidth" statements in the router).

    For capacity calculations on WAN links, you need to take into account the full overhead. This includes the flags that separate the frame relay frames and the FCS. So a full frame bandwidth overhead is 7 bytes (you only count 1 flag) For LAN line capacity, you also need to take into account the FCS, the preamble and start of frame delimiter, which is another 8 bytes on top of your 18 (or 22 in the case of 802.1Q)

    For QoS settings, you disregard the FCS/CRC bytes. This is because these are normally stripped off in the interface hardware and are therefore not seen by IOS. This means that the QOS design guide is right for frame relay (4 bytes). However, most ethernet access is 802.1Q nowadays which requires a layer 2 overhead of an extra 4 bytes on top of the standard 14 bytes ethernet header, giving a total of 18 bytes.

    ATM is an interesting case, where the QoS mechanisms look at the AAL5 level, with just 8 bytes overhead per packet. The actual line overhead with ATM is much greater.

    So they are all sort of right in their own way! It depends what question you are answering.

    peter

  • RELEVANCY SCORE 2.59

    DB:2.59:Pi To Pi Integration? cm



    Hi ,

    One of our client's business partner also use SAP PI. I am lookings for documents/ reference models on PI to PI intetegration.

    regards,

    Arvind Ravindran.

    DB:2.59:Pi To Pi Integration? cm


    Hey,

    This may sound like a dumb question...but let me ask it anyway...

    If Xi can send and receive IDOCs in it native format...it as good as a ECC system..

    Can I treat the external PI system as an ECC system - make the port connections/ partner profile etc... The external PI systems outbound IDOCs will be consumed by my PI system. and I then route it to my ECC system.

    Possible? or just a harebrained idea?

    Regards,

    Arvind

  • RELEVANCY SCORE 2.59

    DB:2.59:Need Help In Opening Point To Point Gprs Datalink 9m


    I havea problem in mention above i have seen MSDN but nothing to find
    plz send me the code of C# ASP.net
    thanks
    basharat

    DB:2.59:Need Help In Opening Point To Point Gprs Datalink 9m

    If you need VPN connection to server, there's no coding involved, just a normal network setup. Please consult your network administrator for help.
    As I already mentioned, device to device connection is not really an option with GPRS.

  • RELEVANCY SCORE 2.56

    DB:2.56:This Oracle Message Does Not Make Sense pp


    I have a Oracle 10G XE which I can access using the username/password:hr/hr

    I can use this information in a DataLink file and then use it with VB.NET 2005, VB.NET 2008 without any problem

    Now I try to set this server as a linked server in SQL Server 2008. My connection information is exactly the same as I use in DataLink which tests OK.

    I use the connection string from the DataLink file. I get the following Oracle error that makes no sense[invlaid logon????).
    =================================
    Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ORA 10G XE".
    OLE DB provider "OraOLEDB.Oracle" for linked server "ORA 10G XE" returned message "ORA-01017: invalid username/password; logon denied". (.Net SqlClient Data Provider)
    =============
    Can any one from Oracle side answer this question as this is going on for ever?Some one must put this to rest.

    DB:2.56:This Oracle Message Does Not Make Sense pp

    I had used the defaults and peraps that was the reason for the error message. I have since used other option and was able to connect. Your question to my question was most appropriate.

    Thanks

    Jayaram Krishnaswamy

  • RELEVANCY SCORE 2.55

    DB:2.55:Diff Between Pi And Leanpi 8m



    Hi All,

    I am new to Process integration (PI ). Can any one explain the difference between PI and Lean Pi in detail.

    Thanks and regards,

    Anil kumar

    DB:2.55:Diff Between Pi And Leanpi 8m


    Hi,

    according to [french SAP web site|http://www12.sap.com/france/campagnes/businessbydesign/get-started/index.epx?olt=CG4DDCB549-08], sorry it's the fault of my google ..., you have probably the same in [this US link|http://www12.sap.com/solutions/products/sap-bydesign/index.epx]...: it seems "Business By Design" is like a small netweaver built in SaaS model, on which we can have three easy starter packs to implement CRM, ERP, services and on which we can (could be able to) add easily other SaaS module (like finance)... without to spend too much money...

    I did not find a direct link to this "lean PI", but as SaaS = Software as a Service, = maybe "lean PI" corresponds to PI 7.3 with only Java stack...

    Even with google, it difficult to find something about "lean PI"... we saw this term only in 2 or 3 CV... so, that should not be an official sap term.

    regards

    mickael

  • RELEVANCY SCORE 2.55

    DB:2.55:Upgrade From Pi 7.0 To Pi 7.1 x1



    Hi SAP PI Consultants

    Any body provide documents for upgrading PI 7.0 PI 7.1.

    Its very helpful for me in my project.

  • RELEVANCY SCORE 2.55

    DB:2.55:Down And Administratively Down 1j



    If you see that an interface is down, there is a problem with the physical layer. If you see it's an administratively down, that means the cable is ok but the interface has been shut down manually or by default. Could it be also a cause that the cable is unplug for the second case?

    A protocol down means the datalink layer has problem or both the network and datalink layers?

    any one please kindly help clerify that. Thanks.

    DB:2.55:Down And Administratively Down 1j


    For Ethernet Interfaces:

    If the routers interface is administratively up (no shut) and there is no cable plugged in, you will see "interface is up, line protocol is down"

    Also, if you have a cable plugged into the device, but the device you are connecting to is down, you will see "interface is up, line protocol is down"

    I believe its different for Serial interfaces where as if you unplug the cable, you can cause a down/down siutation

    If im not mistaken, the first "down" indicates a physical problem (layer 1). The line protocol down indicates a layer 2 issue (not receiving keepalives).

    You can cause an up/up situation with ethernet by using a no keepalives option. But it wont "really" be up.

    Someone please correct me if Im wrong I really havent looked at details of this in a while...

  • RELEVANCY SCORE 2.55

    DB:2.55:How Can I Achieve Outerjoin Type Of Results Using Reports Datalink Option zx


    Hi,

    i am developing a Oracle Report. i am using Datalink to maintain parent-child relationship between 2 queries. If no matching value found then i want to return 0 Records. how to achieve this.
    Ex: I have 2 tables like Dept EMP
    DEPT has 2 rows HR and FINANCE
    I have only one employee in HR and no employee in FINANCE.
    I am using the below datalink properties:
    SQL clause : WHERE
    CONDITION ; =
    PARENT GROUP: DEPT
    PARENT Column : DEPTID
    CHILD QUERY : EMP
    CHILD Column : DEPTID.

    In the report it is showing matching columns without any issues i want non matching columns also with Zero employess like

    HR1
    FINANCE 0
    I need OUTER JOIN kind of thing. How can i achieve this. Just i have written one example. I have very complex query to implement this and datalink is absolutely necessry for me. Any help please.

    DB:2.55:How Can I Achieve Outerjoin Type Of Results Using Reports Datalink Option zx

    I don't want to write no column. Because it is very complex query. using functions make the query easier to read.

  • RELEVANCY SCORE 2.55

    DB:2.55:Datalink Not Functioning cj


    I have a primary SQL query where I fetch sequence1 number. Then I have the second SQL query for details so I also have sequence2 number. I create datalink between this two so I have that relationship sequence1 - sequence2. The problem is when I get sequence1 = 1 in my primary query, it fetch sequence2 = 2 on second query. When I get 2 it gets 2 on second. While if I add the line "and sequence = :sequence1" on my second query, it returns correct data. Can anybody help me to fix this datalink?

    This is on oracle report, (reportbuilder 3.0.5.8.0) and i'm running on oracle forms ver.5

    DB:2.55:Datalink Not Functioning cj

    I have a primary SQL query where I fetch sequence1 number. Then I have the second SQL query for details so I also have sequence2 number. I create datalink between this two so I have that relationship sequence1 - sequence2. The problem is when I get sequence1 = 1 in my primary query, it fetch sequence2 = 2 on second query. When I get 2 it gets 2 on second. While if I add the line "and sequence = :sequence1" on my second query, it returns correct data. Can anybody help me to fix this datalink?

    This is on oracle report, (reportbuilder 3.0.5.8.0) and i'm running on oracle forms ver.5

  • RELEVANCY SCORE 2.55

    DB:2.55:Re: Data Archiving ad


    If your target table is going to save all the historical records of source table. Sri's method is good approach.
    You could either use datalink or even exp/imp to get the source table to target database.

  • RELEVANCY SCORE 2.55

    DB:2.55:Cisco Pi 1.3 Upgrade To Pi 2.0 j8



    Hi all,

    I need the upgrade file that I must install to upgrade cisco PI 1.3 to cisco PI 2.0    ?

    DB:2.55:Cisco Pi 1.3 Upgrade To Pi 2.0 j8


    Here is the downlaod link:

    http://software.cisco.com/download/release.html?mdfid=284422771softwareid=284272932release=2.0.0relind=AVAILABLErellifecycle=reltype=all

    Thanks- Afroz [Do rate the useful post] ****Ratings Encourages Contributors ****

  • RELEVANCY SCORE 2.55

    DB:2.55:How To Create Pi Sheet? zj



    How to create PI Sheet?

    DB:2.55:How To Create Pi Sheet? zj


    Hi Kishore,

    Please do some basic search where you can get lot of information available on PI sheets. Anyway refer the below for more details.

    A Beginner's Guide To PI sheets

    Process Instruction (PI) Sheet

    Thanks Regards,

    Ramagiri

  • RELEVANCY SCORE 2.55

    DB:2.55:National Pi (Pie) Day mp


    It's national pi day!

  • RELEVANCY SCORE 2.55

    DB:2.55:Re: Pi xd


    Anyone know what value of "Pi" is hard coded to in AutoCAD?

    DB:2.55:Re: Pi xd

    Now, there's a tidbit worth saving. Thanks, Jim.
    __
    "Jim Awe" wrote in message
    news:87errr$m9520@adesknews2.autodesk.com...
    I looked it up in Acad source for you:

    #define PI ((double)3.14159265358979323846)

    Jim Awe
    Autodesk, Inc.

  • RELEVANCY SCORE 2.55

    DB:2.55:Pi 7.1 d1



    can any one send me PI 7.1 links

    DB:2.55:Pi 7.1 d1


    Hi

    If u could provide me ur email id i can forward you document on PI7.1.

    below r some links for refrence.

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e00d4c57-dcad-2a10-25a7-fbc5b23abc5e

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/capabilityandEnhancementsofSAPNetWeaverProcessIntegration7.1

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00838345-708c-2a10-1199-9514c0b0a91c

    /people/udo.paltzer/blog/2007/04/26/new-sap-netweaver-process-integration-release-planned-for-2007

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/304335f7-f33c-2a10-ae80-9c9ffdc86415

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00ffdb4d-e869-2a10-7688-891d7eea1b12

    /people/udo.paltzer/blog/2007/04/26/new-sap-netweaver-process-integration-release-planned-for-2007

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/706005a3-3bd6-2910-91ae-a2016239bdcf

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a0e7734f-e969-2a10-24b6-df58a710941c

    /people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-share-user-defined-functions

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/10c0de4b-7876-2a10-e286-8412668643a8

    /people/jin.shin/blog/2008/02/14/sap-pi-71-mapping-enhancements-series-parameterized-message-mappings

    /people/jin.shin/blog/2008/02/14/sap-netweaver-process-integration-71-mapping-enhancements-blog-series

    /people/william.li/blog/2008/02/14/sap-pi-71-mapping-enhancements-series-copy-xml-subtree

    /people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-correct-structural-inconsistencies

    /people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

    /people/paul.read/blog/2007/06/19/new-capabilities-in-sap-netweaver-71-process-integration

    /people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-share-user-defined-functions

    http://help.sap.com/saphelp_nwpi71/helpdata/en/33/1ec6ced273493a993a80c2301c03da/frameset.htm

    /people/sampath.gunda8/blog/2008/02/21/connecting-an-application-to-an-external-database-in-sap-nw-ce-71

    /people/daniel.graversen/blog/2008/02/07/using-ccts-in-pi-71

    /people/william.li/blog/2008/01/10/advanced-adapter-engine-configuration-in-pi-71

    /people/william.li/blog/2008/02/13/point-to-point-connection-using-abap-in-sap-using-pi-71

    /people/william.li/blog/2008/02/07/display-adapter-synchronous-message-content-in-rwb-of-pi-71

    /people/william.li/blog/2007/08/07/using-folders-in-pi-71

    /people/daniel.graversen/blog/2008/04/07/modeling-tools-in-pi-71

    /people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-share-user-defined-functions

    /people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

    /people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-share-user-defined-functions

    /people/william.li/blog/2007/08/07/using-folders-in-pi-71

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8085e299-718c-2a10-de94-928f62b763ce

    /people/udo.paltzer/blog/2007/04/26/new-sap-netweaver-process-integration-release-planned-for-2007

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/10c0de4b-7876-2a10-e286-8412668643a8

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e0068bc1-6f8c-2a10-52bb-c6ee3562feb2

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/808d3048-638c-2a10-35a6-faa48e50ad59

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70b4f0ed-688c-2a10-36bf-a1a9b1a684c9

    award points if found useful

    cheers

  • RELEVANCY SCORE 2.55

    DB:2.55:Printout Of Pi Sheet. k7



    Hi Gurus,

    The client wants a Print out of PI sheet but wants a modified set of standard PI sheet pritnout rather than the original PI sheet.

    Regards,

    Amol Kale

    DB:2.55:Printout Of Pi Sheet. k7


    Hi,

    If you have to print a PI sheet other than standard then please develop a Z transction with the help of your ABAPer.

    Regards,

    Alok Tiwari

  • RELEVANCY SCORE 2.55

    DB:2.55:Abro Excel Y Aparece Una Ventana De Dialogo Y Diceerror De Compilacion En Mudulo Ocultomodaddin Este Mensaje Tiene Que Ver Con La Libreria De Microsoft Visual Basic ck


    Yo utilizo un complemento de un Software llamado PI System el complemento se llama PI DataLink.
    espero y puedan ayudarme....................

    DB:2.55:Abro Excel Y Aparece Una Ventana De Dialogo Y Diceerror De Compilacion En Mudulo Ocultomodaddin Este Mensaje Tiene Que Ver Con La Libreria De Microsoft Visual Basic ck

    hola, erick !
    un error de compilacion significa que el codigo no encuentra algun objeto que requiere para su funcionamiento, en tu caso el modulo se llama "modAddin" y esta oculto (y seguramente con clave) por tratarse de un proyecto de macros protegido contra visualizacion
    (generalmente son complementos de terceros)
    es probable que ese complemento requiera de alguna libreria adicional (.dll, .ocx, etc.) que no esta instalada y debidamente registrada en el equipo donde se ejecuta su codigo y/o que sea necesario (RE)instalar ese complemento (?)
    prueba consultando/preguntando/... en la pagina del creador del complemento
    saludos,
    hector.

  • RELEVANCY SCORE 2.55

    DB:2.55:Bfc: Datalink Definitions sp



    Hi there,

    In using datalink I need to make the following process:

    source:

    account1 analysis1 20000

    account1 analysis2 -10000

    target:

    AccountTarget1 analysis1 20000

    AccountTarget1 analysis2 -10000

    but if I have the following source:

    account1 analysis1 -20000

    account1 analysis2 10000

    I want to get the following result:

    AccountTarget2 analysis1 -20000

    AccountTarget2 analysis2 10000

    I don't want to process line by line but account by account to define the target account.

    any idea?

    Regards,

    Ludovic

    DB:2.55:Bfc: Datalink Definitions sp


    Hi Ludovic

    I think this will be hard to achieve.

    What exactly is your criteria for mapping to either AccountTarget1 or AccountTarget2 - the fact that the sum of amounts is positive/negative ?

    Marc

  • RELEVANCY SCORE 2.55

    DB:2.55:Il Mio Iphone4 Non Si Accende Più xf


    il mio iphone4 non si accende pi

  • RELEVANCY SCORE 2.55

    DB:2.55:New To Pi - Give Tips dj



    Hello Experts,

    I am nee to PI.

    Please send all documentation of SAP PI.

    Thanks

  • RELEVANCY SCORE 2.55

    DB:2.55:Adobe Flash Submenu 8d


    I been trying to redesign one of Flash E-Learning that already been made,All I can change, except the submenu/popup menu text I can't changeHere the is the actionscript that I'm working ononClipEvent (initialize){ _root.unitNo = 3; _root.varLessonNo = 1; barTotal = 5; listSectionTotal = []; listSectionTotal[0] = 1; listSectionTotal[1] = 7; listSectionTotal[2] = 16; listSectionTotal[3] = 1; listSectionTotal[4] = 2; menu = []; menu[0] = "Portal E-Halal"; menu[1] = "Login Permohonan Sistem E-Halal"; menu[2] = "Muka Hadapan"; menu[3] = "Tukar Katalaluan"; menu[4] = "Senarai Ramuan"; _root.seteBook = false; _root.setTab = false; _root.selectedSectionTab = 0; _root.startSeqActivity = 0; _root.startSeqGrammar = 0; dataLink = []; dataLink[0] = "s3_2-s3_7,S231AS1.htm"; dataLink[1] = "s3_8-s3_13,S231AS2.htm"; dataLink[2] = "s3_14-s3_16,S231AS3.htm"; recordingMode = []; recordingMode[0] = 3; recordingMode[1] = 4; _root.TeacherNotesURL = "S231TN.htm";}I already change the menu text but sadly when I play the Swf File the submenu text Wont change from its original textAnyone can help me with this problem?Thanx

    DB:2.55:Adobe Flash Submenu 8d

    I think I found it, The thing is in Component InspectorThanx ned Murphy

  • RELEVANCY SCORE 2.55

    DB:2.55:One Query Or Two Liinked Queries fk


    hi experts

    i want to know what is the better in performance in the report builder is to create one single query with join 2 master and details tables
    or
    create 2 queries one for each table and link them by datalink

    thanks

    DB:2.55:One Query Or Two Liinked Queries fk

    Kurzweil4 u r rite...its better to use one query insted of 2 main queries...

  • RELEVANCY SCORE 2.55

    DB:2.55:Portable Rasbery Pi Mini pa



    The rasbery pi mini could be 2-3x smaller than the regular portable pi

    DB:2.55:Portable Rasbery Pi Mini pa


    The rasbery pi mini could be 2-3x smaller than the regular portable pi

  • RELEVANCY SCORE 2.55

    DB:2.55:Pi Tuning fp



    HI.

    In PI system, how can I decide ,

    MaxThreadCounts and db connecction pooling.

    regards,

    DB:2.55:Pi Tuning fp


    hi,

    refer this blogs

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/423f5046-0a01-0010-2698-b2dc7c3185f1

    regards

    srinivas

  • RELEVANCY SCORE 2.55

    DB:2.55:Dlsw Configuration 81



    Hello,

    i have a router 2911 (c2900-universalk9-mz.SPA.150-1.M4)

    i need to implement a datalink switch with another , but my 2911 don't have a CLI for enable the dlsw.

    Thanks for help

    Sayel

    DB:2.55:Dlsw Configuration 81


    You need to have "DATA" license on your 2900 to do DLSW

  • RELEVANCY SCORE 2.55

    DB:2.55:Pi Sheets 18



    Can anybody explain me the concept of PI sheet,THe need for PI sheet and the complete flow..

    DB:2.55:Pi Sheets 18


    Can anybody explain me the concept of PI sheet,THe need for PI sheet and the complete flow..

  • RELEVANCY SCORE 2.55

    DB:2.55:Pi Instruction Documentation xs


    Hello all.Does somebody here have any useful PI instruction documentation to share ?RegardsFernando

    DB:2.55:Pi Instruction Documentation xs

    Hello,Refer the below links,[Link 01|PI - Sheet Utility;[Link 02|http://help.sap.com/saphelp_46c/helpdata/en/89/a43992461e11d182b50000e829fbfe/frameset.htm][Link 03|http://help.sap.com/saphelp_46c/helpdata/en/89/a4396b461e11d182b50000e829fbfe/content.htm]Please check and revert.ThanksHrishi

  • RELEVANCY SCORE 2.55

    DB:2.55:Upgrading Pi 1.3.0.20 To Pi 1.4 mc



    Hello,

    do I need any upgrade license to migrade from PI 1.3 to PI 1.4 or only a smartnet support is enough? 

    Is there a documentation for the upgrade procedure from PI 1.3 to PI 1.4, I was unable to find it.

     

    Thank you.

     

    Marek

     

    DB:2.55:Upgrading Pi 1.3.0.20 To Pi 1.4 mc


    Hello Rasika,

     

    thank you for this information. I the mean time I found this information in the release notes for PI1.2:

     

    CiscoWorks LMS 2.x/3.x and Cisco Prime LMS 4.0 and 4.1 were offered only with Cisco Software Application Support (SAS). When upgrading to Cisco Prime LMS 4.2 through Cisco Prime Infrastructure 1.2 you can continue with your existing SAS contract for LMS. If you have an LMS 4.x release covered under an SAS contract you are entitled to this and future Cisco Prime Infrastructure 1.x releases at no charge. You also have the option of canceling your existing SAS contract on LMS, obtaining credit for the balance, and purchasing a new SASU contract for Cisco Prime Infrastructure 1.2, which entitles you to free minor and major release upgrades to Cisco Prime Infrastructure.

     

    From this information I suppose that if the customer purchased something like this:
    CON-SAU-PI12LF25

  • RELEVANCY SCORE 2.55

    DB:2.55:Pi Sheet xc



    Hi,

    I have reported PI sheet. Now status of PI is To be complete. Please tell me how to complete the PI sheet

    Srihari

    DB:2.55:Pi Sheet xc


    Goto TCode CO57, choose Process Message Category: PI_CRST,

    Give the process order and control receipe number and change the "Control Recipe Status" to "Control Recipe Discarded".

    Then goto TCode: CO54 and send the Process message from there send the process message

    Regards

    Vinod

    Edited by: Vinod Mohan on Feb 12, 2009 11:45 AM

  • RELEVANCY SCORE 2.55

    DB:2.55:Sap Pi 7.3 9c


    Hi,Can anyone confirm the latest service pack for PI 7.3.RegardsAnandh.B

    DB:2.55:Sap Pi 7.3 9c

    It will cover PI as well. But you should note that some of the service packs may not have anything specific to PI.

  • RELEVANCY SCORE 2.52

    DB:2.52:Sap Pi Developer And Pi Administrator 9a



    Hello All,

    Somebody explain me the differences between the SAP PI developer and PI administrator .

    Would be nice to share the links and comments about there roles.

    Regards

    Shathishkumar

  • RELEVANCY SCORE 2.52

    DB:2.52:Oledb Datalink File Not Connecting For Remote Users f9


    My DataLink file connects to my SQL server fine when I'm logged on locally, but when I hit the Test Connection button from another machine on my Domain or from a Terminal Server session I get the error Microsoft Data Link Error - Test connection failed because of an error in initializing provider. Login failed for user 'Domaine\administrator'. Does anyone know what I'm doing wrong?
    Thank you.

    DB:2.52:Oledb Datalink File Not Connecting For Remote Users f9

    I found that I didn't have the proper permissions set on the terminal server.

  • RELEVANCY SCORE 2.52

    DB:2.52:Question About Data Link sj


    I created a report that uses a data link to get totals. The problem I have is the following.

    Using a data link I create summary columns with a value of 0 if the value is null from the counts the datalink would give.
    but since the datalink return with no value and no repeating frame my summary columns do not exist.

    What should I do to make the summary column return a value of 0

    Howard

    DB:2.52:Question About Data Link sj

    I created a report that uses a data link to get totals. The problem I have is the following.

    Using a data link I create summary columns with a value of 0 if the value is null from the counts the datalink would give.
    but since the datalink return with no value and no repeating frame my summary columns do not exist.

    What should I do to make the summary column return a value of 0

    Howard

  • RELEVANCY SCORE 2.52

    DB:2.52:Pi Sheets 9a



    how to create a pi sheet in master recipe

    DB:2.52:Pi Sheets 9a


    Hi Ravi,

    1.Go to T code C201. or C202 if you have already created master receipe.

    2. go to operations tab

    3.Choose the phase and click oper details

    4.Choose process instr tab

    5.Give the process instructions category one by one and click save.

    Regards

    Ranga

  • RELEVANCY SCORE 2.52

    DB:2.52:Help On Jaxb df


    I am new to JAXB, I would like to seek help from you guys.

    my requirement is, I would like to write an xsd schema for the xml file (tree structure )which is given below .
    Xml sample:

    data language="English"-----------------1

    datalink type="navigational" template="templateid"-------------1.1
    nameString/name
    detaildescriptionString/detaildescription
    imageString/image

    datalink type="navigational" template="templateid"-----------1.1.1
    nameString/name
    detaildescriptionString/detaildescription
    imageString/image

    datalink type="terminal" template="templateid"
    nameString/name
    detaildescriptionString/detaildescription
    imageString/image
    page
    headerString/header
    shortdescriptionString/shortdescription
    imageString/image
    imagedescriptionString/imagedescription
    /page
    /datalink
    /datalink-------------end of 1.1.1

    /datalink----------------end of 1.1

    datalink type="terminal" template="templateid"-------------1.2
    nameString/name
    detaildescriptionString/detaildescription
    imageString/image
    page
    headerString/header
    shortdescriptionString/shortdescription
    imageString/image
    imagedescriptionString/imagedescription
    /page
    /datalink----------end of 1.2
    /data-----------------end of 1

    There are basically two nodes, one is navigational which contains description about the node (i.e. name, detaildescription, image) and also information about the child nodes.
    Second one is a Terminal node, which is some what similar to leaf node.
    Navigational node must contain atleast one terminal node and it can have 'n' number of either navigation node or Terminal nodes (similar to tree structure).
    I would like to write an xsd for above mentioned tree structure and would like to use jaxb to create java equivalent objects. I would like to know how can I implement schema for recursive loop (tree structure) and would like to know whether I can use jaxb for this purpose or I have to use anything else?.

    Thank you.

    Regards,
    Ramki.

    DB:2.52:Help On Jaxb df

    A schema element with elements with same name and different complexType
    generates error:
    "Elements with the same name and in the same scope must have the same type."

    ?xml version='1.0' encoding='UTF-8'?
    !DOCTYPE xs:schema PUBLIC '-//W3C//DTD XMLSCHEMA 200102//EN'
    'http://www.w3.org/2001/XMLSchema.dtd'

    xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"

    xs:element name="data"
    xs:complexType
    xs:sequence
    xs:element name="datalink" type="navigational"/
    xs:element name="datalink" type="terminal"/
    /xs:sequence
    xs:attribute name="language"/
    /xs:complexType
    /xs:element

    xs:complexType name="navigational"
    xs:sequence
    xs:element name="datalink" type="navigational" minOccurs="0" maxOccurs="1"/
    xs:element name="datalink" type="terminal" minOccurs="0" maxOccurs="1"/
    xs:element name="name"/
    xs:element name="detaildescription"/
    xs:element name="image"/
    /xs:sequence
    xs:attribute name="type" type="xs:string"/
    xs:attribute name="template" type="xs:string"/
    /xs:complexType

    xs:complexType name="terminal"
    xs:sequence
    xs:element name="name"/
    xs:element name="detaildescription"/
    xs:element name="image"/
    xs:element name="page"
    xs:complexType
    xs:sequence
    xs:element name="header"/
    xs:element name="shortdescription"/
    xs:element name="image"/
    xs:element name="imagedescription"/
    /xs:sequence
    /xs:complexType
    /xs:element
    /xs:sequence
    xs:attribute name="type" type="xs:string"/
    xs:attribute name="template" type="xs:string"/
    /xs:complexType

    /xs:schema

  • RELEVANCY SCORE 2.52

    DB:2.52:Abap Base Pi Sheet Browser Base Pi Sheet 1c



    Hi

    What is the differance between Browser base PI sheet ABAP base PI sheet.

    DB:2.52:Abap Base Pi Sheet Browser Base Pi Sheet 1c


    Hi,

    From SAP R/3 4.6C version , you can create two different types of PI sheets:

    ABAP list-based PI sheet

    Browser-based PI sheet

    Browser Based PI Sheet is an enhanced version of the old ABAP list-based PI sheet.

    Two of its many advantages are the new user interface in HTML layout as well as new functions.

    It has all the advantages of a browser-based application that is easy-to-operate and intuitive.

    To be able to best use the browser-based PI sheet, you must install Microsoft Internet Explorer 5.0 and above make some security settings in the Internet Explorer.

    You should have an XML converter PARSER software installed so that Browser based PI sheet is totally downloaded correctly.

    Please refer this link,

    [Difference|https://forums.sdn.sap.com/click.jspa?searchID=16673741messageID=5956924]

    Regards,

    R.Brahmankar

  • RELEVANCY SCORE 2.52

    DB:2.52:Re: Pi Symbol xp


    i forgot how to add the pi symbol into and string of text?

    DB:2.52:Re: Pi Symbol xp


    IT IS A GREEK LETTER. IN TEXT EDITOR, GO TO @SYMBOL / OTHER / GREEKC (FONT) / IT'S IN THE FOURTH ROW, LAST COLUMN: U+0070

  • RELEVANCY SCORE 2.52

    DB:2.52:Difference Btw Pi7.0 And Pi 7.1 zf



    Hi Experts

    1 . Can you please tell the difference between PI 7.0 and PI 7.1

    2 . Documents Related to PI 7.1

    Regards,

    B.Jude

    DB:2.52:Difference Btw Pi7.0 And Pi 7.1 zf


    Hi

    Search on SDN with keyword PI7.0 Vs PI7.1.

  • RELEVANCY SCORE 2.52

    DB:2.52:Some Question Of Ppp 97



    I want to know which layer is ppp in the osi?

    Is it in Data link Layer or 2+3 layer??

    Some people told me that ppp has a NCP,it is run in Network layer ,so the ppp is alos in Datalink layer and Network Layer.

    I'm not sure is it correct?

  • RELEVANCY SCORE 2.52

    DB:2.52:Database Link ck


    I have created a datalink

    Create database link connect to username
    identified by password using servicename;

    Database Link Successfully Created.

    Then,
    I tried to access like

    select * from tablename@datalinkname;

    Lakshmi Narayanan

    DB:2.52:Database Link ck

    and what is the problem ?

    Joel Prez

  • RELEVANCY SCORE 2.52

    DB:2.52:Soa And Pi 93



    what is the relationship of SOA with PI

  • RELEVANCY SCORE 2.52

    DB:2.52:Sap Pi Client Change s7



    how to change the default client for PI template based configuration in SAP PI 7.0

    DB:2.52:Sap Pi Client Change s7


    Welcome to SDN.

    Please read the "Rules of Engagement"

    No interview questions allowed.

    If you have a problem please elaborate on it. post full details on scenario and steps already taken.

    Regards

    Juan

  • RELEVANCY SCORE 2.52

    DB:2.52:Pi z9



    Is anyone taking the pI clasd

    DB:2.52:Pi z9


    Is anyone taking the pI clasd

  • RELEVANCY SCORE 2.52

    DB:2.52:Materialized View fm


    I have create a DataLink it was successfully created.

    I give a select statement like

    select * from table name from
    table name@DataLink Name;

    I gives an error

    ORA Error - Credential failed

    Can anyone help on this

    DB:2.52:Materialized View fm

    I have create a DataLink it was successfully created.

    I give a select statement like

    select * from table name from
    table name@DataLink Name;

    I gives an error

    ORA Error - Credential failed

    Can anyone help on this

  • RELEVANCY SCORE 2.52

    DB:2.52:Planning To Upgrade From Pi 7.0 To Pi 7.1 8m



    Hi All,

    Need your help . Planning to upgrade from PI 7.0 to PI 7.1. What are the pre-requisites for PI 7.1.

    earlier version PI 7.0 (SOA) and PI 7.1(Enterprise SOA), Architecutre point of view what's the major difference between PI 7.0 and PI7.1

    DB:2.52:Planning To Upgrade From Pi 7.0 To Pi 7.1 8m


    Ashwin,

    check below link:

    /docs/DOC-7995#section4 [original link is broken]

    Before posting any question, please search in SDN...

    Thanks,

  • RELEVANCY SCORE 2.52

    DB:2.52:Plsql Via Datalink To Remote Database aa


    Hello,

    I have one PLSQL package that does a join of two tables of remote database instance via the datalink. I just wonder where the most calculation(the join) is done, local machine or remote machine? Is there any best practice to have a better performance for such configuration.

    Thanks in advance!

    DB:2.52:Plsql Via Datalink To Remote Database aa

    939569 wrote:

    I have one PLSQL package that does a join of two tables of remote database instance via the datalink. I just wonder where the most calculation(the join) is done, local machine or remote machine? Is there any best practice to have a better performance for such configuration. Distributed joins have the nasty habit of becoming painful performance problems. I have never seen this not to become the eventual case.

    If a local copy of remote data is needed, I prefer using a materialised view. That way you decide when, and how often, to pay for grabbing that remote data - and you do not pay for that every single time over and over again when your local SQL using that data, is executed.

  • RELEVANCY SCORE 2.52

    DB:2.52:Get Path Of Placed Image zm



    Hi,

    I'm trying to get the path of placed images, I understand I am supposed to use the IDataLink to do this (?) but cannot get the datalink.

    I am using the following code I copied from an example...

    UIDRef dataLinkRef = UIDRef::gNull;

    do

    {

    if (splineItemRef.ExistsInDB() == kFalse)

    {

    printf("splineItemRef is invalid!");

    break;

    }

    IDataBase* db = splineItemRef.GetDataBase();

    ASSERT(db);

    InterfacePtrIHierarchy splineHierarchy(splineItemRef, UseDefaultIID());

    if (splineHierarchy == nil)

    {

    printf("splineItemRef is not a page item!");

    break;

    }

    UIDList dataLinkItems(db);

    splineHierarchy-GetDescendents(dataLinkItems, IImageDataAccess::kDefaultIID);

    const int32 nChildren = dataLinkItems.Length();

    if (nChildren == 0)

    {

    printf("The splineItemRef 0x%X does not have a child item. Aborting.", splineItemRef.GetUID().Get());

    break;

    }

    if (nChildren 1)

    {

    printf("The splineItemRef 0x%X has more than one child with IImageDataAccess - choosing first child.", splineItemRef.GetUID().Get());

    }

    const UIDRef childItemRef(dataLinkItems.GetRef(0));

    InterfacePtrIImageDataAccess imageDataAccess(childItemRef, UseDefaultIID());

    InterfacePtrIDataLinkReference dataLinkReference(childItemRef, UseDefaultIID());

    if (imageDataAccess == nil || dataLinkReference == nil)

    {

    printf("childItemRef is not a content item with an image/datalink!");

    break;

    }

    // assign the data link UIDRef

    dataLinkRef = UIDRef(db, dataLinkReference-GetUID());

    if (dataLinkRef == UIDRef::gNull)

    {

    printf("There is no data link boss stored at the datalink reference!");

    break;

    }

    // just to make sure, try querying for IDataLink

    InterfacePtrIDataLink dataLink(dataLinkRef, UseDefaultIID());

    if (dataLink == nil)

    {

    printf("The obtained UIDRef has no IDataLink!");

    dataLinkRef = UIDRef::gNull;

    break;

    }

    } while (false);

    return dataLinkRef;

    DB:2.52:Get Path Of Placed Image zm


    OK, figured it out... For anyone else, check out ILinkUtils.h

    MT