General Technical Discussions for Service

Get Involved. Join the Conversation.

Posts

  • Britto Thatheyu
    ConnectPHP converted code was not able to handle the huge...
    Topic posted 11:14 AM by Britto ThatheyuGreen Ribbon: 100+ Points 
    Title:
    ConnectPHP converted code was not able to handle the huge data...
    Summary:
    ConnectPHP converted code was not able to handle the huge data...
    Content:

    Hi,

    The cron job uses deprecated IAPI(org_create/org_update) function to import the bulk data. As part of the upgrade process,we are trying to replace these deprecated functions with relevant ConnectPHP object model, but cron job is failing with below error message

    FIRST_OCCUR: 05/17/19 05:31:06
    LAST_OCCUR: 05/17/19 05:31:06
    DB API Error
       API Fcn: execute() [SQLStatement.cpp: 632]
     Called By: app_trans_sql_insert() [transactions.c: 526]
     SQL Error: Records: 2  Duplicates: 0  Warnings: 0
       Message: Unable to allocate sufficient storage for queryPointer!

       
    As per our understanding, the ConnectPHP doesn't allow to commit more than 97k plus records in a single execution. We have also tried to split the import files into multiple batches and reset the file pointer/variable, but it is still failing with the same error.
     

    To overcome this issue, we break the huge import file(110MB) into multiple batch(5.5MB) files and loop through it. Inside the loop, initiate the CURL call to trigger another custom script to process the batch files. Each request only can process maximum 8k records, since it calls through the HTTP request.

    Please advise, whether the above workaround is having any impact OR do we have any other better solution to achieve this use case?

    Thanks & Regards!
    Britto Thatheyu S.

  • Kurt Helfrich
    Contact update error "Maximum number of active SQL...
    Topic posted 8:49 AM by Kurt HelfrichGold Trophy: 10,000+ Points 
    Title:
    Contact update error "Maximum number of active SQL statements exceeded"
    Summary:
    Just upgraded to 19A over the weekend, and now I can't multi-edit contacts as before
    Content:

    We just upgraded to 19A from 18A over the weekend.  Everything seemed to work well, until I was trying to change the org for a number of contacts this morning.  I've used the same report for up to 250 contacts at a time in the past, but today, for only 19 contacts, I got a new error: Maximum number of active SQL statements exceeded.

    I tried rebuilding the local cache of the .NET client, but no joy.

    I didn't see anything in the KB or other posts - has anyone else ever seen this?  Any ideas on how to fix it?

    Version:
    19A
    Image:
  • Sharon Levin
    "past from word" in the Advanced Knowledge...2
    Topic posted May 6, 2019 by Sharon Levin 
    Title:
    "past from word" in the Advanced Knowledge CKEditor
    Summary:
    recommended word version to use "past from word" in the Advanced Knowledge CKEditor
    Content:

    Hi

    what word version (office doc file) is the recommended version for pasting content into the CKEditor ?

     

    I want to edit a text in a word document and want to use the recommended doc version to make sure no formatting will lost during pasting the content from word into CKEditor .

     

    Thanks

    Sharon 

    Version:
    9.b
    Image:
  • Pramod Vasudeva Murthy
    [Agent BUI]: Open a Report from BUI1
    Topic posted May 4, 2019 by Pramod Vasudeva MurthyBlack Diamond: 60,000+ Points 
    Title:
    [Agent BUI]: Open a Report from BUI
    Summary:
    Open a report and another record as a child tab
    Content:

    Hi All,

    Is it possible from the BUI to open a report on the click of a button? And, also open a workspace as a child tab to an object?

    I searched the BUI docs, did not get enough information. Wanted to know if there anyways around?

    Thank you,

    Pramod V

    Version:
    19A
  • JLFolkman
    Blocking bots1
    Topic posted April 26, 2019 by JLFolkman Silver Trophy: 7,500+ Points 
    Title:
    Blocking bots
    Summary:
    Blocking bots
    Content:

    Does Oracle Service Cloud have any tools or recommendations for blocking unwanted bots (like thousandeyes)?

  • Sylvia S
    SRM Accelerator Report import error2
    Topic posted April 25, 2019 by Sylvia SBronze Medal: 1,250+ Points 
    Title:
    SRM Accelerator Report import error
    Summary:
    Error when importing SrmRepliesListTable.xml
    Content:

    Hi Guys,

    Has anyone experienced this error when importing the SrmRepliesListTable.xml (downloaded from github). See attached. Any way i resolve this. One of the solutions suggested from this post: https://cloudcustomerconnect.oracle.com/posts/0c7cfca5bd?page=2 was to manually create a report from the SrmRepliesList table that is generated by one of the add-ins. However, i am not able to see the table in the list of tables of the data dictionary. I can only see the SocialChannelAccount(Accelerators$SocialChannelAccount).

    Regards,

    Sylvia

     

     

    Image:
  • mikewaldron
    time_t's In BUI Extension Paths45.0
    Topic posted April 21, 2019 by mikewaldron Red Ribbon: 250+ Points 
    Title:
    time_t's In BUI Extension Paths
    Summary:
    Paths to BUI extension components seem to include a time_t in the path - when does this change?
    Content:

    We've started writing a lot of extensions for the Agent Browser UI (BUI), and we've pretty well converged on Vue.js as our Javascript application framework of choice. When building for production, we need to be able to tell Vue's build process where the "publicPath" is. I know how to do this, and I can get the value from Chrome's developer tools in the application tab. However, the path looks like this:

    /AgentWeb/api/agentbrowserui/api/agentBrowserExtensions/1550253505000/browserExtension/mjw%20Testbed

    where the "1550253505000" appears to be a time_t (seconds since the epoch, in this case April 21, 2019 @2237).

    My question is this: When does that path component change? Is it set when an extension is first created and then fixed for that extension's lifetime? That appears to be the case, but I need to know for sure before I commit to relying on it in a production extension.

     

  • Aaron Aitken
    Product Registration form Catalog search15.0
    Topic posted April 10, 2019 by Aaron Aitken 
    Title:
    Product Registration form Catalog search
    Summary:
    Product Registration form that searches the Product Catalog
    Content:

    Hello ,

    I am looking for the correct way and widget to use when creating a Product Registration page. This would have to search the product database and allow the customer to select (click) on the product they want to register when it shows up. They would then be able to enter in the product information (example: Serial Number, Date Purchased etc.) .

    -> Once his information is entered a hidden filed will show asking for all the customers information (Name, E-mail, Address, Phone, Etc.), also having a way for them to opt-in for promotional emails.

    --> This page would have to check against current (Registered) users to see if the account creation is needed using email address. Or it would just allow them register the product only and not create a full user account.

    - - - Update: April 11, 2019 - - -

    I have been able to add a search function to this page (Please see code Snippet) that looks to our knowledge base and can pull up the searched Item correctly. I am still looking to find out how to feed the search output back to the page so that when the user enters their account information (mailing address, phone etc.) it can be saved as a new registration record.

    -

    Oracle Service Cloud August 2017 (Build 333 SP 5, CP 333)

    Framework Version 3.7

    Version:
    Framework Version 3.7
    Image:
    Code Snippet:
  • Tracey Weetman
    How to Retrieve List of ENTITY Names for ERP Object DFF...
    Topic posted April 10, 2019 by Tracey Weetman 
    Title:
    How to Retrieve List of ENTITY Names for ERP Object DFF Update Service
    Summary:
    Need to find list of ENTITY Names for ERP Object DFF Update Web Service
    Content:

    How can I retrieve a list of ERP Object Names using the web service.

    Eg:  If I want to update the AR_PAYMENT_SCHEDULE DFF Attributes using the ErpObjectDFFUpdateService what is the Entity Name for AR Payment Schedule etc..

    For AR Invoices, the Entity Name is 'Receivables Invoice' and I need to get a list of available items which would include the AR Payment Schedule DFFs

     

  • Amy Chan
    Add logic validation on standard field in cloud.Answered3
    Topic posted March 14, 2019 by Amy ChanSilver Medal: 2,000+ Points 
    Title:
    Add logic validation on standard field in cloud.
    Summary:
    Add logic validation on standard field in cloud.
    Content:

    Is it possible to add logic validation on standard field in cloud? For example: when user submits Purchase Order for approval, one of the DFF value requires start with "ABC", otherwise a message return.

    Please share.

Filter by Date

< < May 2019 > >
S M T W T F S
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

Filter by Type