Stephen Smith's Blog

Musings on Machine Learning…

The Sage ERP Accpac 6.0A Portal

with 97 comments


The Sage ERP Accpac 6 Portal is the new Desktop that runs in a browser. Sometimes the word Portal beings up connotations of other things, I’m not sure if a better name is Landing Page, Home Page, Web Desktop, or Start Page. But when you run Accpac 6, this is where you will begin. The primary goal of this Portal is to allow you to navigate into the Accpac application as quickly and intuitively as possible.

When you login to the new Portal, rather than being presented with a tree of icons, you get a dashboard of information useful for doing your job. You can start work by drilling down from the dashboard to get to more detailed reports and inquiry screens. You can run screens by using the “My Shortcuts” area to run frequently accessed screens. Then if you really need the full tree of icons it is available under the Tasks menu.

Customization of the “Home” page and “My Shortcuts” area has been mad as easy as possible, so that any user can easily set these up in an optimal way for their role.

As you run additional tasks, new tabs are opened and you can switch back and forth between them.

Reports still use Crystal Reports but show the results using the Crystal web view in a separate tab in the Portal.

Hopefully this gives an idea of where we are going with the new Sage ERP Accpac 6 Web Desktop/Portal/Home Page. We feel we have come a long way from our original desktop, adding a lot of usability and making the product far more friendly to new and experienced users.

Advertisements

Written by smist08

December 3, 2009 at 12:40 am

Posted in Uncategorized

Tagged with , ,

97 Responses

Subscribe to comments with RSS.

  1. We’re a SalesLogix / SageCRM VAR, very active in blogging for many years, with a focus on tech. Just wanted to to let you know that you a a very good blog going here. Going to include you in the Sage GeekFetch feed on Twitter. It’s in private mode right now, but your posts will be included when we go live on Jan 1. Kudos.

    David Tinjum

    December 5, 2009 at 1:24 am

  2. Was that a financial report generated by Crystal?!

    Django Dunn

    December 10, 2009 at 1:38 pm

    • Yes it is. But the portlet is setting up the data for it.

      smist08

      December 12, 2009 at 10:09 pm

  3. Hi Smist,

    First congrats & best wishes for ACCPAC 6.0.

    I am R. Rengarajan, working in Sage ACCPAC ERP 5.x for 6 Years in DPP Partner company. Bangalore. India.

    I am very happy to see development in Accpac 6.0.

    I have some questions.

    1. Is Sage ACCPAC 6.0 fully webbased?. VB Screens will be exists?
    2. We have product for Hospital Information system. which was developed using Sage ACCPAC 5.5 SDK. All of Business logic were written in View level.. Shall we use the same and just replacing with Accpac 6?. Or we have to develop from scratch?

    3. To develop a module in Accpac 6.0? What are all pre-request should be avaliable. like, sdk, screen design software.

    Thanks
    Rengarajan.

    Rengarajan

    December 18, 2009 at 7:50 pm

    • 1. The goal is to become fully web based. However the VB screens will still be supported for quite a few versions. We will let the market decide when they can be phased out. But we expect them to be around quite a long time due to DPP solutions like yours and due to customer’s customizations.

      2. You will keep your Business Logic Views just the same. You will just need to replace the user interface layer with UIs developed in the 6.0 SDK.

      3. Our new Sage Web Toolkit (SWT) is based on Google’s GWT, which means all UI work will be done in Java. Reading about GWT and Java would be a good start.

      Cheers

      smist08

      December 19, 2009 at 5:37 am

      • Thanks you.

        Rengarajan

        December 19, 2009 at 6:31 pm

      • HI Smist,

        Myself, Mohan in-charge of IT in one of the big hospitals in Bangalore .We are using the Hospital Information system developed by Rengarajan and team, we are upgrading to version 6.0, just one clarification about the user set criteria is there any solution to export set criteria from version 5.5 to version 6.0 directly as there are more than 250 users.

        Cheers
        Mohan

        Mohan

        April 2, 2015 at 1:07 pm

      • These are stored in the user folder of the shared data folder in the company_p.ism files. usually if you upgrade these would be preserved and this wouldn’t be lost. If you created a new separate install, then you might want to migrate these over (copy them).

        smist08

        April 2, 2015 at 3:19 pm

  4. […] have created a slick "desktop running in a browser", as can be seen from the screenshots below and here. This is an impressive showcase demonstrating the use of the Google Web Toolkit to develop large […]

  5. Hi, we would prefer a hosted, web based solution where our data is stored and backed up by Sage. Will version 6.0 live in on the web? We’re considering switching from our local version of Accpac to the current hosted version, but I don’t want to go to the trouble if 6.0 is what we’re really looking for. If there is a hosted version of 6.0, will we still need to login via a Citrix connection?

    Rick MacKirdy

    February 23, 2010 at 4:48 am

    • That will happen, but not for a few years. Our immediate goal is to move Accpac to be a web based application that is installed on-premise. Once we are finished moving the entire application with all its options and modules to becoming true web based, then we will considering replacing the Citrix infrastructure we currently use at AccpacOnline. Part of this will depend on market demand for a hosted versus on-premise solution.

      So for version 6.0, yes you will still need to login via a Citrix connection.

      Hope this helps.

      smist08

      February 24, 2010 at 12:38 am

  6. When will the 6.0 sdk be released to development partners

    zahir

    February 26, 2010 at 7:18 pm

  7. […] run Web based User Interface forms. We’ve covered how this looks in several other blog posts like https://smist08.wordpress.com/2009/12/03/the-sage-erp-accpac-6-0a-portal/ and https://smist08.wordpress.com/2009/12/24/sage-erp-accpac-6-0-data-portlets/. But as a developer, […]

  8. Smith,

    I’ve been working with accpac related sales activities for awhile. but my real burn is to get in to pre-sales or technical. what would you advice me to do???….

    MMS

    September 25, 2010 at 6:58 pm

    • I think a good route to pre-sales is to be a certified consultant first. This gives experience with the products, on how to install them, how they fit into customer environments and how the customers use the software. This then helps with seeing in a pre-sales setting whether the ERP software will fit well with the customers needs.

      smist08

      September 27, 2010 at 3:09 pm

  9. […] menu or from the easily customized shortcuts bar. For more information on the new portal see:  https://smist08.wordpress.com/2009/12/03/the-sage-erp-accpac-6-0a-portal/ and for more information on running accounting screens see:  […]

  10. […] ERP Accpac 6.0A comes with a new Web Portal (https://smist08.wordpress.com/2009/12/03/the-sage-erp-accpac-6-0a-portal/) along with Web based screen integration to SageCRM […]

  11. […] The Sage ERP Accpac 6.0A Portal Sage ERP Accpac 6.0 Adhoc Query Sage ERP Accpac 6.0 Quote to Orders Sage ERP Accpac 6.0 Data Portlets Sage ERP Accpac 6.0 – Locking Fiscal Periods by Module Drilling Down from Crystal Reports in Sage ERP Accpac 6 Running Classic Forms in Sage ERP Accpac 6 Sage ERP Accpac 6 User Assistance […]

  12. […] working on Sage ERP Accpac 6.1A. Accpac 6.0 introduced our new Web Based technologies with the new Portal, Dashboards, Inquiry tool and Quote to Orders. With Accpac 6.1 we are now looking to fill out the […]

  13. […] learn more about Sage ERP Accpac 6.0A including the new Web Portal, new Web Based CRM Integration, Dashboards, new Inquiry tool and more, please attend our Virtual […]

  14. […] Sage ERP Accpac 6.0A Web Portal provides a nice home page of relevant accounting information to act as a starting point for […]

  15. And how would I get to have this error: “The server cannot process the request for UI content. Contact your Sage ERP Accpac administrator for assistance” sorted on the portal?
    At IIS all services are running well/

    Raymond Cheruiyot

    April 11, 2011 at 9:35 am

    • Usually this means it couldn’t create the uiContent table in the Portal database the first time it is hit. Did you run Database Setup and configure a Portal database from the “Portal…” button? Another cause is doing this from IE6, which will fail at this point. If these parts look ok, go into the database manager and make sure uiContent was created, if it was remove it so it gets re-created.

      smist08

      April 11, 2011 at 3:08 pm

      • Hey thanks Smist! I deleted the UIContent as let the system recreate and Voila! It worked!

        Raymond Cheruiyot

        April 11, 2011 at 3:36 pm

      • hi smith, where to delete the uiContent? Also encountered the same error. thanks!

        cha alo

        April 19, 2011 at 1:43 pm

      • It is a table in the Portal database that you setup. If you are using SQL Server then you can go into the SQL Server Management Studio, open the Portal database, choose tables and delete the uiContent table.

        smist08

        April 19, 2011 at 2:41 pm

  16. what if using Pervasive.SQL? thanks for the reply.

    cha alo

    April 22, 2011 at 7:29 am

    • Then you would just do the same thing in the Pervasive Control Center.

      smist08

      April 22, 2011 at 3:39 pm

      • I couldn’t locate the uiContent table in Pervasive Control Center. Can you please provide the steps in detail or provide screenshot?

        Cecy

        July 21, 2011 at 3:50 am

      • Perhaps it wasn’t created. You should check the SDataServlet.log in the program files(x86)\common files\sage\sage accpac\tomcat6\logs folder, perhaps there is an error message there.

        smist08

        July 21, 2011 at 2:56 pm

      • Thanks for your prompt reply. I’ve checked the error message in the log folder. It says “ibGetCmpLinkNo domain ib value 65535”.

        The weird thing is that I installed both MSSQL and PSQL in the same workstation. I don’t even need to delete the UIContent for MSSQL and the web portal works fine. But, as for PSQL, I’ll get the above error message after click ‘sign in’ at web portal.

        Any idea how to solve this?

        Cecy

        July 26, 2011 at 5:49 am

      • This error has nothing to do with the Portal database or uiContent. This is trying to connect to your Accpac company database. Can you sign-on to Accpac using the regular Accpac windows desktop? You might need to run DBSpy to see what is going on.

        smist08

        July 26, 2011 at 10:23 pm

      • I’ve run the DBSpy and got the following log file. Could you please help me to see what’s the problem? Thanks in advance.

        ======================================================================
        DBSpy Log Date: 08-08-2011 Time: 10:51:56.83
        ======================================================================

        Link 0: SAMINC, AS9010; Read-Only – CLOSED
        >>> created the following URI
        btrv:///?table=DATADICT
        Using version 10.30 of Btrieve Requester
        Using version 10.30 of Btrieve
        >>> wCheckPSQLInstall is about to begin
        >>> setup returned (0) dbUser dbPwd remote data? no remote engine? no connection -1
        >>> path C:\SAGE SOFTWARE\SAGE ACCPAC\SAMPLE\SAMINC remote (SAMINC, CECY_WIN7PC, 0.0) local (SAMINC, CECY_WIN7PC, 10.30)
        >>> wCheckPSQLInstall seeks DSN SAMINC (found? yes)
        >>> wCheckPSQLInstall seeks dbname SAMINC locally (found? yes)
        >>> no change in security settings at this time!
        >>> local install is not client – we shall call PvModifyDatabase
        >>> wCheckPSQLInstall URI=> btrv://CECY_WIN7PC/SAMINC
        >>> connected successfully using B_LOGIN call
        >>> wCheckPSQLInstall: at exit DSN exists – returning DBS_SUCCESS
        >>>> Connect: opening dictionaries
        >> start by attempting to open the dictionaries
        BtrvDDOpen([local:CECY_WIN7PC] at entry hDict = ffff, path = C:\SAGE SOFTWARE\SAGE ACCPAC\SAMPLE\SAMINC)
        * BtrvDDOpen(at exit – 1)
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=DATADICT
        10:21:55.41 GET-DRVR-INFO ( )
        10:21:55.41
        10:21:55.41 OPEN-TABLE ( table=CSAPP , flags=0 )
        >> allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:55.43 handle <– 0
        10:21:55.43 SELECT ( handle=0, filter=, keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        10:21:55.47
        10:21:55.48 FETCH ( handle=CSAPP-0, fetch=20 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“AP”,”00″)
        ## key fetched: (“AR”,”00″)
        ## key fetched: (“AS”,”00″)
        ## key fetched: (“BK”,”00″)
        ## key fetched: (“CS”,”00″)
        ## key fetched: (“GL”,”00″)
        ## key fetched: (“GP”,”00″)
        ## key fetched: (“IC”,”00″)
        ## key fetched: (“OE”,”00″)
        ## key fetched: (“PM”,”00″)
        ## key fetched: (“PO”,”00″)
        ## key fetched: (“TX”,”00″)
        ## key fetched: (“UP”,”00″)
        ## key fetched: (“UT”,”00″)
        mapping error 9 in class 3
        10:21:55.53 ==> 121 , fetched > allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:55.75 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        >>> key sought: (“??”,”??”)
        <<< key retrieved: ("AP","00")
        10:21:55.76 [ $ F1 = 'AP',\41\50 $ F2 = '00' ]
        10:21:55.77 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("AR","00")
        10:21:55.77 [ $ F1 = 'AR',\41\52 $ F2 = '00' ]
        10:21:55.77 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("AS","00")
        10:21:55.78 [ $ F1 = 'AS',\41\53 $ F2 = '00' ]
        10:21:55.78 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("BK","00")
        10:21:55.78 [ $ F1 = 'BK',\42\4b $ F2 = '00' ]
        10:21:55.78 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("CS","00")
        10:21:55.79 [ $ F1 = 'CS',\43\53 $ F2 = '00' ]
        10:21:55.79 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("GL","00")
        10:21:55.79 [ $ F1 = 'GL',\47\4c $ F2 = '00' ]
        10:21:55.79 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("GP","00")
        10:21:55.80 [ $ F1 = 'GP',\47\50 $ F2 = '00' ]
        10:21:55.80 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("IC","00")
        10:21:55.81 [ $ F1 = 'IC',\49\43 $ F2 = '00' ]
        10:21:55.81 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("OE","00")
        10:21:55.81 [ $ F1 = 'OE',\4f\45 $ F2 = '00' ]
        10:21:55.81 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("PM","00")
        10:21:55.82 [ $ F1 = 'PM',\50\4d $ F2 = '00' ]
        10:21:55.82 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("PO","00")
        10:21:55.82 [ $ F1 = 'PO',\50\4f $ F2 = '00' ]
        10:21:55.83 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("TX","00")
        10:21:55.83 [ $ F1 = 'TX',\54\58 $ F2 = '00' ]
        10:21:55.83 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("UP","00")
        10:21:55.84 [ $ F1 = 'UP',\55\50 $ F2 = '00' ]
        10:21:55.84 GET-NEXT ( handle=CSAPP-0 )
        << 121
        10:21:55.85 CLOSE-TABLE ( handle=CSAPP-0 )
        10:21:55.85
        10:21:56.08 OPEN-TABLE ( table=CSCOM , flags=1 )
        >> allocating buffer for 36 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col ORGID, flags x100
        10:21:56.09 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSCOM
        >>> key sought: (“SAMINC”)
        <<> allocating buffer for 36 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col FSCYEAR, flags x100
        10:21:56.24 handle <– 0
        10:21:56.24 SELECT ( handle=0, filter=BGNDATE1 >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSFSC
        10:21:56.26
        10:21:56.26 FETCH ( handle=CSFSC-0, fetch=1 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“2020”)
        10:21:56.27 fetched >> back from SQLDriverConnect, did we succeed?
        [ODBC] allocating new statement handle in wQueryInit
        [ODBC] about to execute: select PGMID, PGMVER from “CSFSC”,”CSAPP” where CSFSC.FSCYEAR = ‘2020’ and CSAPP.SEQUENCE = ’00’ and (exists (select * from “CSFSCST” where CSFSCST.FSCYEAR = CSFSC.FSCYEAR and CSFSCST.PGMID = CSAPP.PGMID and CSFSCST.STATUS8 = 0) or not exists (select * from “CSFSCST” where CSFSCST.FSCYEAR = CSFSC.FSCYEAR and CSFSCST.PGMID = CSAPP.PGMID) )
        10:21:56.55 handle 121
        10:21:56.60 QUERY-FREE ( handle=0 )
        ## immediate end to ODBC connection
        [ODBC] shutting down the connection
        10:21:56.78
        10:21:56.78 OPEN-TABLE ( table=CSCCD , flags=1 )
        >> allocating buffer for 12 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col CURID, flags x100
        10:21:56.80 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSCCD
        >>> key sought: (“USD”)
        <<> allocating buffer for 27 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col IDP01, flags x100
        10:21:56.90 handle = “APP01 “)), keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=APP01
        10:21:56.97
        10:21:56.98 FETCH ( handle=APP01-0, fetch=8 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“APP01.”)
        mapping error 9 in class 3
        10:21:56.99 ==> 121 , fetched > allocating buffer for 18 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col RECID02, flags x100
        10:21:57.01 handle = “APP02 “)), keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=APP02
        10:21:57.03
        10:21:57.03 FETCH ( handle=APP02-0, fetch=8 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“APP02.”)
        mapping error 9 in class 3
        10:21:57.04 ==> 121 , fetched > allocating buffer for 72 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col RECID03, flags x100
        10:21:57.06 handle = “APP03 “)), keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=APP03
        10:21:57.08
        10:21:57.08 FETCH ( handle=APP03-0, fetch=8 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“APP03.”)
        mapping error 9 in class 3
        10:21:57.09 ==> 121 , fetched > allocating buffer for 32 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col IDR01, flags x100
        10:21:57.13 handle = “R01”)), keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=ARR01
        10:21:57.16
        10:21:57.16 FETCH ( handle=ARR01-0, fetch=8 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“R01”)
        mapping error 9 in class 3
        10:21:57.17 ==> 121 , fetched > allocating buffer for 57 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col IDR02, flags x100
        10:21:57.20 handle = “R02”)), keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=ARR02
        10:21:57.23
        10:21:57.23 FETCH ( handle=ARR02-0, fetch=8 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“R02”)
        mapping error 9 in class 3
        10:21:57.24 ==> 121 , fetched > allocating buffer for 44 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col IDR03, flags x100
        10:21:57.26 handle = “R03”)), keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=ARR03
        10:21:57.28
        10:21:57.28 FETCH ( handle=ARR03-0, fetch=8 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“R03”)
        mapping error 9 in class 3
        10:21:57.29 ==> 121 , fetched > allocating buffer for 47 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col OPTIONID, flags x100
        10:21:57.51 handle = “GL01”)), keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=GL01
        10:21:57.55
        10:21:57.55 FETCH ( handle=GL01-0, fetch=8 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“GL01”)
        mapping error 9 in class 3
        10:21:57.56 ==> 121 , fetched > allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:57.66 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        >>> key sought: (“OE”,”00″)
        <<>> key sought: (“AR”,”00″)
        <<> allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:57.70 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        >>> key sought: (“LT”,”00″)
        <<> allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:57.73 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        >>> key sought: (“SN”,”00″)
        <<> allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:57.83 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        >>> key sought: (“PM”,”00″)
        <<> allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:57.92 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        >>> key sought: (“??”,”??”)
        <<< key retrieved: ("AP","00")
        10:21:57.94 [ $ F1 = 'AP',\41\50 $ F2 = '00' ]
        10:21:57.94 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("AR","00")
        10:21:57.94 [ $ F1 = 'AR',\41\52 $ F2 = '00' ]
        10:21:57.95 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("AS","00")
        10:21:57.95 [ $ F1 = 'AS',\41\53 $ F2 = '00' ]
        10:21:57.95 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("BK","00")
        10:21:57.96 [ $ F1 = 'BK',\42\4b $ F2 = '00' ]
        10:21:57.96 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("CS","00")
        10:21:57.96 [ $ F1 = 'CS',\43\53 $ F2 = '00' ]
        10:21:57.96 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("GL","00")
        10:21:57.97 [ $ F1 = 'GL',\47\4c $ F2 = '00' ]
        10:21:57.97 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("GP","00")
        10:21:57.97 [ $ F1 = 'GP',\47\50 $ F2 = '00' ]
        10:21:57.98 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("IC","00")
        10:21:57.98 [ $ F1 = 'IC',\49\43 $ F2 = '00' ]
        10:21:57.98 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("OE","00")
        10:21:57.99 [ $ F1 = 'OE',\4f\45 $ F2 = '00' ]
        10:21:57.99 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("PM","00")
        10:21:57.99 [ $ F1 = 'PM',\50\4d $ F2 = '00' ]
        10:21:57.99 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("PO","00")
        10:21:58.00 [ $ F1 = 'PO',\50\4f $ F2 = '00' ]
        10:21:58.00 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("TX","00")
        10:21:58.00 [ $ F1 = 'TX',\54\58 $ F2 = '00' ]
        10:21:58.00 GET-NEXT ( handle=CSAPP-0 )
        <<< key retrieved: ("UP","00")
        10:21:58.01 [ $ F1 = 'UP',\55\50 $ F2 = '00' ]
        10:21:58.01 GET-NEXT ( handle=CSAPP-0 )
        << 121
        10:21:58.02 CLOSE-TABLE ( handle=CSAPP-0 )
        10:21:58.02
        10:21:58.14 OPEN-TABLE ( table=CSAPP , flags=0 )
        >> allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:58.16 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        >>> key sought: (“IC”,”00″)
        <<>> key sought: (“OE”,”00″)
        <<>> key sought: (“PM”,”00″)
        <<> allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:58.21 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSAPP
        >>> key sought: (“PM”,”00″)
        <<> allocating buffer for 25 fields
        >> num app keys = 1 with 1 segements
        >> index 0 segment 0 col SCHEDKEY, flags x100
        10:21:58.81 handle >> created the following URI
        btrv://CECY_WIN7PC/SAMINC?table=CSSKTB
        10:21:58.84
        10:21:58.84 FETCH ( handle=CSSKTB-0, fetch=8 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“MONTHLY…..”)
        ## key fetched: (“WEEKLY……”)
        mapping error 9 in class 3
        10:21:58.85 ==> 121 , fetched >> created the following URI
        btrv:///?table=DATADICT
        Using version 10.30 of Btrieve Requester
        Using version 10.30 of Btrieve
        >>> wCheckPSQLInstall is about to begin
        >>> setup returned (0) dbUser dbPwd remote data? no remote engine? no connection -1
        >>> path C:\SAGE SOFTWARE\SAGE ACCPAC\SAMPLE\SAMSYS remote (SAMSYS, CECY_WIN7PC, 0.0) local (SAMSYS, CECY_WIN7PC, 10.30)
        >>> wCheckPSQLInstall seeks DSN SAMSYS (found? yes)
        >>> wCheckPSQLInstall seeks dbname SAMSYS locally (found? yes)
        >>> no change in security settings at this time!
        >>> local install is not client – we shall call PvModifyDatabase
        >>> wCheckPSQLInstall URI=> btrv://CECY_WIN7PC/SAMSYS
        >>> connected successfully using B_LOGIN call
        >>> wCheckPSQLInstall: at exit DSN exists – returning DBS_SUCCESS
        >>>> Connect: opening dictionaries
        >> start by attempting to open the dictionaries
        BtrvDDOpen([local:CECY_WIN7PC] at entry hDict = ffff, path = C:\SAGE SOFTWARE\SAGE ACCPAC\SAMPLE\SAMSYS)
        * BtrvDDOpen(at exit – 2)
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMSYS?table=DATADICT
        10:21:55.67 GET-DRVR-INFO ( )
        10:21:55.68
        10:21:55.68 OPEN-TABLE ( table=CSAPP , flags=0 )
        >> allocating buffer for 9 fields
        >> num app keys = 1 with 2 segements
        >> index 0 segment 0 col SELECTOR, flags x110
        >> index 0 segment 1 col SEQUENCE, flags x100
        10:21:55.69 handle <– 0
        10:21:55.69 SELECT ( handle=0, filter=, keyno=0, ascending=1 )
        >>> created the following URI
        btrv://CECY_WIN7PC/SAMSYS?table=CSAPP
        10:21:55.70
        10:21:55.71 FETCH ( handle=CSAPP-0, fetch=20 )
        ## btrv_Fetch is looking for records
        ## key fetched: (“AS”,”00″)
        mapping error 9 in class 3
        10:21:55.72 ==> 121 , fetched <– 1
        10:21:55.72 CLOSE-TABLE ( handle=CSAPP-0 )
        10:21:55.72
        BtrvDDClose(hDict = 2)
        10:21:55.73 UNLINK ( )

        Link 2: SLTD60, AS9010; Read-Only
        10:40:38.06 GET-DRVR-INFO ( )
        10:40:38.06
        10:40:38.06 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:38.06 handle <– 0
        10:40:38.06 SELECT ( handle=0, filter=, keyno=0, ascending=1 )
        10:40:38.06
        10:40:38.07 FETCH ( handle=CSAPP-0, fetch=20 )
        10:40:38.07 ==> 121 , fetched <– 14
        10:40:38.07 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:38.07
        10:40:38.29 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:38.29 handle 121
        10:40:38.34 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:38.34
        10:40:38.57 OPEN-TABLE ( table=CSCOM , flags=1 )
        10:40:38.58 handle <– 0
        10:40:38.58 GET ( handle=CSCOM-0, keyno=0 [ $ F1 = 'SLTD60' ] )
        10:40:38.58 [ $ F1 = 'SLTD60' ]
        10:40:38.58 CLOSE-TABLE ( handle=CSCOM-0 )
        10:40:38.58
        10:40:38.66 OPEN-TABLE ( table=CSFSC , flags=1 )
        10:40:38.66 handle <– 0
        10:40:38.66 SELECT ( handle=0, filter=BGNDATE1 <= 20200808, keyno=0, ascending=0 )
        10:40:38.66
        10:40:38.67 FETCH ( handle=CSFSC-0, fetch=1 )
        10:40:38.67 fetched <– 1 [ $ F1 = '2020' ]
        10:40:38.67 CLOSE-TABLE ( handle=CSFSC-0 )
        10:40:38.67
        10:40:38.68 QUERY-RUN ( query=select PGMID, PGMVER from "CSFSC","CSAPP" where CSFSC.FSCYEAR = '2020' and CSAPP.SEQUENCE = '00' and (exists (select * from "CSFSCST" where CSFSCST.FSCYEAR = CSFSC.FSCYEAR and CSFSCST.PGMID = CSAPP.PGMID and CSFSCST.STATUS8 = 0) or not exists (select * from "CSFSCST" where CSFSCST.FSCYEAR = CSFSC.FSCYEAR and CSFSCST.PGMID = CSAPP.PGMID) ), flags=0 )
        10:40:38.68 handle 121
        10:40:38.71 QUERY-FREE ( handle=0 )
        10:40:38.71
        10:40:38.71 OPEN-TABLE ( table=CSCCD , flags=1 )
        10:40:38.72 handle <– 0
        10:40:38.72 GET ( handle=CSCCD-0, keyno=0 [ $ F1 = 'CAD' ] )
        10:40:38.72 [ $ F1 = 'CAD' ]
        10:40:38.72 CLOSE-TABLE ( handle=CSCCD-0 )
        10:40:38.72
        10:40:38.73 OPEN-TABLE ( table=APP01 , flags=1 )
        10:40:38.74 handle = “APP01 “)), keyno=0, ascending=1 )
        10:40:38.75
        10:40:38.75 FETCH ( handle=APP01-0, fetch=8 )
        10:40:38.76 ==> 121 , fetched <– 1
        10:40:38.76 CLOSE-TABLE ( handle=APP01-0 )
        10:40:38.76
        10:40:38.76 OPEN-TABLE ( table=APP02 , flags=1 )
        10:40:38.77 handle = “APP02 “)), keyno=0, ascending=1 )
        10:40:38.78
        10:40:38.78 FETCH ( handle=APP02-0, fetch=8 )
        10:40:38.79 ==> 121 , fetched <– 1
        10:40:38.79 CLOSE-TABLE ( handle=APP02-0 )
        10:40:38.79
        10:40:38.79 OPEN-TABLE ( table=APP03 , flags=1 )
        10:40:38.80 handle = “APP03 “)), keyno=0, ascending=1 )
        10:40:38.81
        10:40:38.81 FETCH ( handle=APP03-0, fetch=8 )
        10:40:38.82 ==> 121 , fetched <– 1
        10:40:38.82 CLOSE-TABLE ( handle=APP03-0 )
        10:40:38.82
        10:40:38.83 OPEN-TABLE ( table=ARR01 , flags=1 )
        10:40:38.83 handle = “R01”)), keyno=0, ascending=1 )
        10:40:38.85
        10:40:38.85 FETCH ( handle=ARR01-0, fetch=8 )
        10:40:38.85 ==> 121 , fetched <– 1
        10:40:38.85 CLOSE-TABLE ( handle=ARR01-0 )
        10:40:38.86
        10:40:38.86 OPEN-TABLE ( table=ARR02 , flags=1 )
        10:40:38.86 handle = “R02”)), keyno=0, ascending=1 )
        10:40:38.88
        10:40:38.88 FETCH ( handle=ARR02-0, fetch=8 )
        10:40:38.88 ==> 121 , fetched <– 1
        10:40:38.89 CLOSE-TABLE ( handle=ARR02-0 )
        10:40:38.89
        10:40:38.89 OPEN-TABLE ( table=ARR03 , flags=1 )
        10:40:38.90 handle = “R03”)), keyno=0, ascending=1 )
        10:40:38.91
        10:40:38.91 FETCH ( handle=ARR03-0, fetch=8 )
        10:40:38.92 ==> 121 , fetched <– 1
        10:40:38.92 CLOSE-TABLE ( handle=ARR03-0 )
        10:40:38.92
        10:40:38.93 OPEN-TABLE ( table=GL01 , flags=1 )
        10:40:38.94 handle = “GL01”)), keyno=0, ascending=1 )
        10:40:38.95
        10:40:38.96 FETCH ( handle=GL01-0, fetch=8 )
        10:40:38.96 ==> 121 , fetched <– 1
        10:40:38.96 CLOSE-TABLE ( handle=GL01-0 )
        10:40:38.96
        10:40:38.97 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:38.97 handle <– 0
        10:40:38.97 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'OE',\4f\45 $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:38.98 [ $ F1 = 'OE',\4f\45 $ F2 = '00' ]
        10:40:38.98 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'AR',\41\52 $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:38.98 [ $ F1 = 'AR',\41\52 $ F2 = '00' ]
        10:40:38.99 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:38.99
        10:40:38.99 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:38.99 handle <– 0
        10:40:38.99 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'LT',\4c\54 $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:39.00 [ $ F1 = 'OE',\4f\45 $ F2 = '00' ]
        10:40:39.00 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:39.00
        10:40:39.01 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:39.01 handle <– 0
        10:40:39.01 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'SN',\53\4e $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:39.01 [ $ F1 = 'TX',\54\58 $ F2 = '00' ]
        10:40:39.02 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:39.02
        10:40:39.03 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:39.03 handle <– 0
        10:40:39.03 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'PM',\50\4d $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:39.04 [ $ F1 = 'PM',\50\4d $ F2 = '00' ]
        10:40:39.04 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:39.04
        10:40:39.05 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:39.05 handle 121
        10:40:39.11 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:39.12
        10:40:39.12 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:39.12 handle <– 0
        10:40:39.13 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'IC',\49\43 $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:39.13 [ $ F1 = 'IC',\49\43 $ F2 = '00' ]
        10:40:39.13 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'OE',\4f\45 $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:39.14 [ $ F1 = 'OE',\4f\45 $ F2 = '00' ]
        10:40:39.14 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'PM',\50\4d $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:39.14 [ $ F1 = 'PM',\50\4d $ F2 = '00' ]
        10:40:39.14 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:39.15
        10:40:39.15 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:39.15 handle <– 0
        10:40:39.15 GET-GE ( handle=CSAPP-0, keyno=0 [ $ F1 = 'PM',\50\4d $ F2 = '00' ], filtersegs=0, expdrecs=0 )
        10:40:39.15 [ $ F1 = 'PM',\50\4d $ F2 = '00' ]
        10:40:39.16 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:39.16
        10:40:39.34 OPEN-TABLE ( table=CSSKTB , flags=1 )
        10:40:39.36 handle 121 , fetched <– 0
        10:40:39.41 CLOSE-TABLE ( handle=CSSKTB-0 )
        10:40:39.42

        Link 3: SSYS60, AS9010; Read-Write – CLOSED
        10:40:38.26 GET-DRVR-INFO ( )
        10:40:38.26
        10:40:38.26 OPEN-TABLE ( table=CSAPP , flags=0 )
        10:40:38.27 handle <– 0
        10:40:38.27 SELECT ( handle=0, filter=, keyno=0, ascending=1 )
        10:40:38.27
        10:40:38.27 FETCH ( handle=CSAPP-0, fetch=20 )
        10:40:38.28 ==> 121 , fetched <– 1
        10:40:38.28 CLOSE-TABLE ( handle=CSAPP-0 )
        10:40:38.28
        10:40:38.28 UNLINK ( )

        Cecy

        August 8, 2011 at 2:46 am

      • The log looks fine. I don’t see any errors. You’ll probably have to follow up with support to see what is going one.

        smist08

        August 8, 2011 at 4:40 pm

  17. My client is running is on Sage ERP ACCPAC 6.0 erp 200 edition on MSQL Database. On trying to configure the portal database, there is an error that pops up; Is ERP 200 portal operational? This is the second site giving me the same error…

    Raymond Cheruiyot

    May 24, 2011 at 6:20 am

    • It does work. What is the error? Are you using multiple SQL Server instances? Are you using SQL Server Express? Perhaps have a look at: https://smist08.wordpress.com/2011/03/05/diagnosing-problems-with-sage-erp-accpac-6-0a/

      smist08

      May 24, 2011 at 6:03 pm

      • Hi Smith, there is only one instant of the database; The error is “Could not find the main Class. Program will exit”

        Raymond Cheruiyot

        May 25, 2011 at 7:55 am

      • Hi Smith,there is only one instant of the database; The error is “Could not find the main Class. Program will exit”

        Raymond Cheruiyot

        May 25, 2011 at 7:56 am

      • For this case, its trying to run the batch file in the accpac\portal.config directory. It could be a bad Java runtime, you could try uninstalling all versions of Java and then reinstalling only the latest version of Java. You could also try running the batch file directly to see if you can get more information.

        smist08

        May 25, 2011 at 3:30 pm

  18. Hello Smist; Great thanks for your reply. I tried running the batch file directly but it took me to the same error; I will uninstall all versions of java and rerun the installation, will keep you on the loop….

    Raymond Cheruiyot

    May 25, 2011 at 3:36 pm

  19. […] feature of Sage ERP Accpac 6.0A that adds easy to use Inquiry/Reporting functionality to the new Sage ERP Accpac Web Portal. The Inquiry tool, out of the box, comes with a number of predefined Inquiry templates for G/L, A/R […]

  20. Hi Stephen

    I am getting the following error when opening my SAGE Accpac 6.0 Portal
    “Could not initialize class com.sage.accpac.sm.SharedDataSet”

    What is causing this error and how can I fix it. Need help please.

    Derick Pretorius

    August 17, 2011 at 2:02 pm

    • This is probably the first place the Java layer is trying to call into the DLLs in the accpac\runtime folder. Perhaps the Accpac\runtime folder isn’t in the system PATH (it must be here for the Windows services to access it). It could also be a security thing where perhaps the Sage Accpac Tomcat6 service doesn’t have sufficient access rights to access the accpac\runtime folder, perhaps because of network rights or something?

      smist08

      August 17, 2011 at 3:42 pm

  21. Hi Stephen

    I had a look at my Path and it has the ACCPAC\RUNTIME in there. I don’t know how to check or give access to a service like Tomcat6 for allowing it more rights to a folder. Please help here.

    Derick Pretorius

    August 18, 2011 at 6:48 am

    • We install the Sage Accpac Tomcat6 service to use the local administrator account. This account can do anything on the local computer, but can’t access network resources. If Accpac or the shared data are located on another computer, then you need to go to the Control Panel – Admin Services – Service, right click on the Sage ERP Accpac Tomcat6 service and change the user it runs under to a domain user with sufficient rights. Sometimes its just easier to install Accpac locally on the web server.

      smist08

      August 18, 2011 at 3:41 pm

  22. Hello Smith,
    Getting Error, “The server cannot process the request for UI content. Contact your Sage ERP Accpac administrator for assistance” sorted on the portal?
    Configuration : Win 7(64bit) / Sql Server 2008 / IIS 7.5 / Accpac 500 ver 6.0
    1. Was working fine on first installation of Sage Accpac
    2. giving error when added social site contain in .xms files for demo purpose [as guided in http://community.sageaccpac.com/blogs/r_and_d/default.aspx?PageIndex=2%5D to delete the UIContent table from your Portal database
    3. after that giving error, tried uninstallation of compete Accpac & reinstallation but error is same.
    4. Log shows : 2011-09-14 19:51:55,134 ERROR [com.sage.orion.sdata.servlet.swtservice.tablebuilder.JDBCTableBuilder:672] – Violation of PRIMARY KEY constraint ‘PK__UIConten__634F6E860AD2A005’. Cannot insert duplicate key in object ‘dbo.UIContent’.
    5. pl. help to reconfigure and start using portal.
    Thanks

    Shahid Akhtar

    September 15, 2011 at 6:58 am

    • I think you have a bug (typo) in the XML files you added to the uicontent section under tomat\portal\swtservices\… Since you added these files, uninstalling won’t remove them. Try deleting the files you added, then drop the uiContent table in SQL and try again.

      smist08

      September 15, 2011 at 9:10 pm

  23. Getting the following error “An unexpected error occurred when trying to open Batch List.” This is while trying to access Sage Accpac 6.0 via web portal. Login goes through successfully but none of the modules opens.

    Elvis Rono

    October 6, 2011 at 11:44 am

    • The Batch List is a VB UI, for this to work you need Workstation Setup installed on your computer. Also you need to let the ActiveX control that launches VB UIs install when you start the Portal.

      smist08

      October 6, 2011 at 2:59 pm

      • Am having a similar error on Sage 300 ERP 2012. Login is successful but no screen are opening over a remote PC. I have run workstation setup but still wont work.

        Mwiinga

        November 11, 2013 at 8:29 am

      • Make sure you can run the screens from the regular Desktop from the Start Menu. If this works, then perhaps you have ActiveX controls disabled in IE? Or plugins disabled if you are using one of the other browsers.

        smist08

        November 11, 2013 at 10:45 pm

    • Hi,

      Am getting the following errors while running Sage 300 erp portal
      An unexpected error occurred when trying to open Options. Run Workstation Setup and try again. If the error persists, contact your Sage 300 ERP administrator for assistance.

      Joy

      June 11, 2014 at 2:26 pm

      • any solution available to resolve this error? thanks a lot

        Joy

        June 11, 2014 at 2:27 pm

  24. I am having a problem of the Portal button in Database Setup is greyed out so I can’t even configure it. What could that be please?

    Karen

    January 30, 2012 at 6:35 pm

    • Check that the Portal components have been installed. You can run the Accpac install and choose modify to confirm that the Portal has been selected.

      smist08

      January 30, 2012 at 7:52 pm

      • It is installed. I even uninstalled and re-installed it and rebooted the server for good measure 🙂

        Karen

        January 30, 2012 at 7:54 pm

  25. Also, when trying to click on Configure Tomcat Service it gives me this error: The specified service does not exist as an installed service. Unable to open the service “SageAccPacTomcat6”

    Karen

    January 30, 2012 at 9:03 pm

    • If you run Control Panel – Administrative Tools – Services, do you see the Sage Accpac Tomcat 6 service? If not then something failed during the installation. You might want to check the Window’s Event Viewer to see if it has any hints as to what might of failed and why.

      smist08

      January 31, 2012 at 12:30 am

  26. […] however, the product as it shipped only defined a few SData feeds that it needed to support the new Web Portal, Data Snapshots, Inquiry Tool and Quotes to Orders features. But Sage 300’s support for SData is […]

  27. We have recently upgraded to Version 6.0 of Accpac and were told that we now have this “fantastic” Portal available to us. After many hours of attemted support by our Service Provider we are now told it won’t work on our installation. The error I am getting is:
    The server cannot process the request for UI content. Contact your Sage ERP Accpac administrator for assistance.

    What I found so far is that IE6 is not working but the Consultant did not know. I have now checked from a machine that is running IE9 and I am getting the same error. I have tried to delete the UI Table in the Portal Database on SQL Server but the SQL Server has no tables.

    Our consultant has now told me that it won’t work for us unless we rebuild the system. This does not sound right to me and I wonn’t be able to do this as it is high risk process and would be very expensive. Hope you can help.

    Thanks.

    rsa01

    March 14, 2012 at 1:15 pm

    • You could check out my blog posting at: https://smist08.wordpress.com/2011/03/05/diagnosing-problems-with-sage-erp-accpac-6-0a/. It seems like the Accpac server can’t access the portal database. Perhaps try going into Accpac’s Database Setup and clicking the Portal… button and ensuring (by clicking OK) that it can really access the Portal database (that nothing has changed since you first did this).

      smist08

      March 14, 2012 at 9:28 pm

      • Thanks. I have done this re portal and there is communication as if i put a wrong password it rejects. The problem is that there are no tables created in the portal database itself. I have done an uninstall and reinstall and also deleted and recreated the portal database but nothing seems to rectify the portal database. Can it be manually created or is there a trigger to recreate ita.

        Rsa01

        March 14, 2012 at 9:47 pm

      • It creates and loads these tables the first time they are accessed. If you use IE6, it will definitely hang during this process and nothing will be created. Usually if you can setup in database setup then it will go ahead and create the tables. It might be worth turning up the diagnostic level on SDataServlet and seeing if anything useful appears in this log.

        For Tomcat and SDataServlet, the log files are stored in: C:\Program Files (x86)\Common Files\Sage\Sage Accpac\Tomcat6\logs . To configure the logging level edit: C:\Program Files (x86)\Common Files\Sage\Sage Accpac\Tomcat6\webapps\SDataServlet\WEB-INF\classes\log4j.properties and change “log4j.rootLogger=ERROR, logfile” to “log4j.rootLogger=ALL, logfile”.

        You need to stop and re-start the Sage Accpac Tomcat6 Windows Service for this change to take effect.

        smist08

        March 14, 2012 at 10:13 pm

  28. Is Accpac web portal can run outside office?

    sofia

    April 25, 2012 at 3:15 am

  29. Hi Smist08,

    Is Accpac 6.0 web portal can access outside? Because i am having a problem when run the module outside office. Here’s the error.
    “An unexpected error occurred when trying to open Batch List.” This is while trying to access Sage Accpac 6.0 via web portal. Login goes through successfully but none of the modules opens.

    sofia

    April 25, 2012 at 6:06 am

    • You can only run the Web parts of the product outside the office. This includes the Portal, data snapshots, Inquiry tool and quotes to orders (part of our CRM integration). You can’t run the older Windows based screen over the web, these require workstation setup to be run in order to work.

      smist08

      April 25, 2012 at 6:04 pm

      • Hi Smist08,

        Thanks for the prompt response. I already run the workstation setup to this laptop. When the client is in the office she can access through web portal those Accpac transaction like AR invoice, payment and others without error but when she’s outside office the user can only access those snapshots like AP aged for the transaction the above error appear. Is it only means that outside can only access those snapshots like reports. Please advice.

        Thanks in Advance.

        sofia

        April 26, 2012 at 1:41 am

      • That is correct, because the older Windows screens are using Internet technology. If they additionally had a VPN connection to their work network it should work, but will likely be slow.

        smist08

        April 26, 2012 at 4:46 pm

  30. Hi Smist,

    Sorry to bother you again. Is there any special installation needed for web portal to run? Because VPN set already but then when the user is outside office the data entry for remote portal still cannot access and this error keep prompting when trying to access GL batch for example.

    Error: “An unexpected error occurred when trying to open invoice batch list. Run WS setup and try again. If error persist contact your Sage ERP administrator for assistance”.

    sofia

    May 8, 2012 at 9:06 am

    • You might try running the regular Windows Desktop to see if that works. To make sure all the resources necessary are available over the VPN.

      smist08

      May 8, 2012 at 7:21 pm

      • When i tried running regular windows desktop no error occured. also when i tried running the open inside office with the same network environment. But when i go out to office and use different connect and tried to tick in data entry error occurred. I am not very sure that this web portal only run with the same network whether in or out office. Thanks and advise.

        sofia

        May 9, 2012 at 6:04 am

      • Very strange. If you can run UIs from the regular desktop, then I would expect you could also run them from the portal. Not sure what is going wrong here. Suspect you’ll have to take this up with support.

        smist08

        May 10, 2012 at 2:48 pm

  31. […] introduced the Sage 300 ERP Inquiry tool in our 6.0A release. This tool was part of the new Web Based Portal. I blogged about it here, this blog was written before release when we were call it the Adhoc Query […]

  32. Hi Smist08,

    Just a follow up question. For example when i use Accpac web portal using different network outside office if the data entry from a web portal can be accessible or it will give me the above error. Sage said the data entry can only be accessible if i use the same network environment but in this case i use different connection outside.

    Please confirm and advise. Thanks a lot

    sofia

    May 23, 2012 at 5:41 am

    • That’s why I was saying you need to use a VPN, then this gives you the same network environment even when you are outside your network.

      smist08

      May 23, 2012 at 10:42 pm

      • Thanks Smits08.

        sofia

        May 29, 2012 at 7:50 am

  33. Hi Smists,

    Can i check with you? I have encountered error while trying to export the PO transaction in excel file using data only. Error “Failed to export report”. Only encountered in workstation, in server can export.

    Accpac Version: 5.6 line 200
    Excel 2010

    Please advise.

    sofia

    May 30, 2012 at 2:16 am

  34. Hello Smith,
    I have developed an interface between Sage 300 ERP and an external application. The interface is on a a web page and would like to have it as a shortcut within 6.0 ACCPAC Portal. What is it that I need to do so as to realize this? Very important please…

    Raymond Cheruiyot

    October 15, 2012 at 10:53 am

  35. Hi, I appreciate what are doing here! I have some problems viewing crystal report viewer reports like income stmt etc; it always prompts for database sa’s password, but it won;t still go through I will appreciate your help.

    Secondly, is it possible to work with the portal from another country? if yes what are the modalities?

    airnorr

    April 1, 2013 at 5:49 pm

  36. Hi,
    i need help on how to configure the portal because when i open the portal, it brings alot of errors and words appear on top of each other and when i try to open any batch list or screen, this error comes up; ”An unexpected error occurred when trying to open Journal Entry. Run Workstation Setup and try again.
    If the error persists, contact your Sage ERP Accpac administrator for assistance.” i have tried running the workstation setup but it’s not changing, your help will be well appreciated,,.

    tmalowa

    April 5, 2013 at 7:26 am

    • Depends what version you are running and in which browser. Remember 6.0A only supports running in IE. Version 2012 supports all the browsers. Overlapping text is usually an indicator of an unsupported browser. If it is supported, try clearing the browser cache and retrying, perhaps something was missed or corrupted on download. For running the batch list, you do need to have workstation setup installed to run the older VB screens.

      smist08

      April 5, 2013 at 4:35 pm

  37. Hi smith! I successfully installed and activated the SAGE ACCPAC 6.0 programs and portal on a server. I also run the workstation setup on each workstations that will connect to ACCPAC and successfully run the SAGE ACCPAC 6.0 on each workstation.

    However, when I run the portal on the workstation, it didn’t run. IE10 says that the page cannot be displayed, make sure that the web address is correct (http://server_name is correct.) I just map the program on the server running SAGE ACCPAC during workstation installation. I don’t what configuration I am missing.

    Appreciates your help very much!

    NDEGUZMAN

    April 22, 2013 at 7:47 am

  38. Hi Smith. I created a shortcut in the start menu as advise. However I still couldn’t run the Portal on the Workstations. URL shortcut created was. (http://XB11/SageERPAccpac/portal60a/portal.html) wherein XB11 is my server name. I don’t know what I am missing. I supposed this should be working at this stage. The portal is working on the Server but not on the workstations.

    Appreciate your help very much!

    NDEGUZMAN

    April 29, 2013 at 6:28 am

    • What’s the error your get? If the screen just comes up blank it might be that the Portal database didn’t get fully created. Might be worth deleting any tables in the Portal database, clearing the browser cache and trying again. Remember that the first time you hit the portal, you need to wait 5 minutes or so for the Portal database to load (there should be a spinner on the screen while this happens).

      smist08

      April 29, 2013 at 3:05 pm

      • IE10 says “This page can’t be displayed”
        – Make sure the web address http://xb11 is correct
        – Look for the page with your search engine
        – Refresh the page in a few minutes

        I’ve done clearing the cache and browsing history and even restore the setting of the IE10 brower on the workstation. I also delete the Portal database tables as advise. I still couldn’t connect to the portal from the workstation. But when i launch the portal directly in the server, its working. I think I am missing something..
        Appreciates your help.

        NDEGUZMAN

        April 30, 2013 at 2:39 am

      • Make sure you use the full URL: http://XB11/SageERPAccpac/portal60a/portal.html. It could also be that there is some sort of DNS issue. Perhaps try using the IP address in place of the host name (see if ping XB11 returns a valid IP Address).

        smist08

        April 30, 2013 at 3:46 am

  39. I had the spinning orb problem was was able to fix it by giving the SYSTEM user permissions on the SQL database at the database level. Now the website loads. The SYSTEM user is also the user running my app pool in IIS, so if your apppool is run by a different user, you may need to give that user database permissions.

    Keep in mind the new link is /Sage300erp/portal61a/portal.html , note the 61 not 60, as this is with PU1.
    woot!

    whatsinaname

    May 8, 2013 at 7:48 pm

  40. […] For more information on this Portal, have a look at this blog posting. […]

  41. […] For more information on this Portal, have a look at this blog posting. […]

  42. […] multi-threaded operation in version 5.6A and then fully used it starting with version 6.0A for the Portal and Quote to Orders. Since then we’ve been improving our multi-threading as it is a very […]

  43. […] are calling this a Home Page rather than a Portal to avoid confusion with the 6.0A Portal, the Partner Portal and all sorts of other Portals. This isn’t meant to be an all-in-one entry […]

  44. […] had similar data widgets in our Sage 300 6.0 Portal, these new KPIs leverage what was developed there as well, for instance to display aging or to […]

  45. How can set l The Maximum memory pool setting in the Java tabbed window of the Sage Accpac Tomcat 6 Properties window to 1024 MB.

    chen

    November 25, 2015 at 5:16 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: