SAP

560

Solutions

847

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have a new user that connects to SAP Crystal Reports XI via remote desktop.  Crystal opens fine for him, but F5 and "Refresh Report Data" are unresponsive with no error displayed.  Save data with report is unchecked.  I can run the same reports with no issues.  
He is able to successfully refresh and run reports he has created, but nothing previously written.  I did have him open an older report and hit "verify database", but that had no effect either.
Is it possible that this is related the remote desktop connection rather than a setting or problem with Crystal?
Thanks!
0
Exploring SQL Server 2016: Fundamentals
LVL 13
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

Hello Experts Team
I am searching for good resources  on internet and books for crm on premises administration  (Functional-Technical)as I did before on crm 2011 and 2013 and then changed to another system Sap and would like to refresh my skills again for  deployment  and configuration of dynamics crm on Premises as I am system administrator and like to enhance my skills again .
Waiting for your kind advice
0
Hi EE ,

I want to Cofigure backup for  a Client (SAP/Oracle) using EMC Networker Version 8.2

OS:Linux 7.4
Database:oracle12C
Application:SAP

Any one can help me step by step ?  

Also can show me the restore procedure Step by step

Thanks
0
We wanted to implement a security requirement in our Sybase DB to check for 3 generation of password history. we read about the stored procedure named sp_extrapwdchecks , however based on my limited knowledge it only handle 1 generation of password for 12 months. Will like to check if anyone has implemented such requirement before and leveraging the same stored procedure.  Thank you
0
Dear users, in SAP -> Project I should try some way to show in the list also the deleted projects. I tried some different solutions, how is the best choice to do this? There is i.e. a way to directly access to SAP cloud database?

Thank you very much!

P.S. i.e. I could create a very simple in VB.NET / C# / Access to retrieve this data from original tables, the query were very simple. Obviously, only in read access.
0
I am trying to create a datasource in SAP web interface environment (Datasources -> new -> join datasource, is the second item) . My purpose is to create a join between different datasource. Some tables appears without any problem, but with other datasource I see the message "Datasource not available for join (...) you are trying temp. join". Why? Thank you very much.
0
I am trying to get a CF.net application(Visual Studio.net 2008) on windows CE 5 talking to a sybase 16 SQL anywhere instance.  I cannot find any a good example of SAConnection string.

Here are a few versions i have tried so far. Any help would be appreciated

Imports iAnywhere.Data.SQLAnywhere  

Dim conn As SAConnection

conn = New SAConnection("SERVER=192.168.92.125;PORT=2638;UID=user1;PWD=password1;")
conn = New SAConnection("Data Source=192.168.92.125;Port=2638;Uid=user1;Pwd=password1;")
conn = New SAConnection("Data Source=192.168.92.125,2638;Uid=user1;Pwd=password1;")
0
Removing Business Objects from SAP and still Using Crystal Reports..

I have read several threads and they really don't make sense to me

Will I still be able to go into BEx Query Designer and create queries and then report off of these queries in Crystal?
Will these queries look any different in Crystal than they do know.. Fields etx…?
Will I be able to publish these Crystal Reports that are designed off of these BEx Queries and publish via Email with SAP Managed security?

Loaded questions but I need more "Layman" answers.. Please help if possible
0
Using SAP IDT to connect to multiple servers.  Its seem like the connection to the one Sybase 16 database keeps failing sporadically.  The error  "[Data Federator Driver] Cannot reach server. Reason:  attempt to establish connection failed:java.net.ConnectionException:  Connection refused: connect (local port 51490 to address... ).  The error as I said is sporadic.

I'm adding a post I found online that is identical to the issue i'm having although it was posted June of 2018, and I believe we're SQL 2016 and i'm trying to hit Sybase 16.  I'm trying to gather information to take to my Business Objects admin there at work.
idtError2019-05-16_7-33-01.jpg
idt2019-05-16_7-51-18.jpg
0
Hi.

I am want to code a python program to connect to SAP. I use the PyRFC library.

With the following code:
from pyrfc import Connection

Open in new window


I am getting the error:
ImportError                               Traceback (most recent call last)
<ipython-input-14-c21fcdc26a13> in <module>()
----> 1 from pyrfc import Connection

ImportError: cannot import name 'Connection'
0
HTML5 and CSS3 Fundamentals
LVL 13
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

background, we host SAP onsite, Version 9.1
windows 10 machine - latest updates
Antivirus - Sophos endpoint
Encryption - bitlocker

Sap randomley crashes and gives us this error:

The description for Event ID 1000 from source Application Error cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

SAP Business One.exe
9.10.180.0
55b66d89
B1_Engines.dll
9.10.180.0
55b656a6
c000041d
0025121c
3f70
01d4fb37bfbaf172
C:\Program Files (x86)\SAP\SAP Business One\SAP Business One.exe
C:\Program Files (x86)\SAP\SAP Business One\B1_Engines.dll
945ce100-9174-4f26-99bf-d66d0c84b785

The handle is invalid
0
Need to install SAP Cristal  Reports veiwer on about 50 computers. I have a domain but they don't have an msi file option. Our users don't have local admin rights to install the software otherwise , I could ask them to do it. Anyway that I can push this somehow without an msi file. We have 2012 domain controlers.
0
Having trouble connection to Sybase server using sql editor Squrriel.  Following stack errors:

java.sql.SQLException: Unable to create connection. Check your URL.
      at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:151)
      at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:148)
      at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.lambda$execute$0(OpenConnectionCommand.java:93)
      at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
0
SAP Crystal Reports.

I have a table with 5 columns in the table, which has a Left Outer Join to display the correct data, etc. However I need to doing something special on this report I am building for our Production floor.

The table is called 'UPC' however in the 'UPC' table the system/software keeps both the Carton Label and the UPC for a particular product. The issue is that even though they are both being kept in there, they are not in the same order.

Example would be for Product #123, UPC maybe the second inserted record in the DB and the Carton label would be the first but for Product #456, it would be visa-versa, etc. So who ever entered in the data, or it could be just the system itself, didn't put it in the same order (1. UPC 2.) Carton Label), etc. So on this Crystal Reports, I would like to build two (maybe two) 'formula' where it would it see that the # starts a '1' then it is a Carton Label and put it in the Carton Label area and if it starts with a '0', it would be a UPC, etc.


Of the top of my head, it would be 1 forumula but with both math formulas in there used twice? I'm not sure, but if someone could point me in the right direction, I would appreciate it.
0
Unable to  sum a number of hours per month in a business object report. see document attached.  I am getting several rows per month

BO_REPORT_ISSUE.docx
0
Environment:
  • IBM Power9/PowerVM LPARs
  • Intel x86_64/vSphere 6.7 VMs (using EFI)
  • SuSE Manager (SUMA) 3.2
  • SLES 15

I'm attempting to create a build infrastructure for both PPC LPARs and x86 VMs using a single SUMA.

By following the SuSE Documentation for Deploying SLES on Power, I am able to build SLES 15 on Power9/PowerVM LPARs.

My problem now is getting the same infrastructure to also build SLES 15 on x86_64/vSphere VMs.

I am able to build SLES 15 on the VMs using the ISOs - so there is nothing intrinsically wrong with the VMware environment. I also was able to produce an AutoYaST profile from an install.

The DHCP server on SUMA correctly identifies the VMs and assigns an IP address from the proper range, and also properly directs the VM to load the grub.efi file. Watching via WireShark, I see the VM successfully transfer the file using TFTP.

And then nothing happens.....

If I boot the VM into the boot selection screen and manually initiate the PXE boot via a network interface, it gets the file and cycles back to the boot selection screen. Lather, rinse, repeat. I never get a GRUB menu, the installer never starts, nothing.

Looking at the docs I linked above, there is some custom GRUB configuration and a special Cobbler …
0
Hi All,

I am working on a new project which is SAP eWM implementation.

Now reading on SAP official site i understand i need to do a blueprint but they don’t have any sample of blueprints, can someone please share SAP eWM blueprint sample or template with me please?

Need this help urgently.

Thanks

A
0
I'm getting the following error 7235 while starting backup service when discovering the solutions, find the KB for Error 7234/7235

Error: 7235, Severity: 17, State: 0  No other query entry found for the remote server SYBASESRV_BS - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.   

Open in new window


after issuing the following dump command line to Check that the remote server is up and running. I got the below error :

1> exec SYB_BACKUP...sp_who
2> go

If Backup Server is running, will get a meaningful response to this query. Unfourantly, we got the below error

Msg 7205, Level 17, State 2:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Server boot directory.
Msg 7205, Level 18, State 3:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Open in new window


as per the Action plan, we should check the interface file and I am not able to find the interface file yet. I would appreciate if anyone can share thoughts on this, please.
0
Want to print continuous crystal report using from range, below attaching image of what i want to achieve:

How can i print continuous crystal report?
Also i'm using this code to print single report
public void GetInvoiceRpt(string strReportName, string strVno)
        {
            try
            {
                int compcode = Convert.ToInt32(Application.Current.Properties["CompId"]);

                ReportDocument cryRpt = new ReportDocument();
                TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
                TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
                ConnectionInfo crConnectionInfo = new ConnectionInfo();
                Tables CrTables;


                cryRpt.Load(strReportName);

                crConnectionInfo.ServerName = clsconnection.SQLServerName();
                crConnectionInfo.DatabaseName = "MyApplication" + clsconnection.getCompanyCode(compcode);
                crConnectionInfo.UserID = clsconnection.SQLLoginID();
                crConnectionInfo.Password = clsconnection.SQLPW();
                CrTables = cryRpt.Database.Tables;
                foreach (Table CrTable in CrTables)
                {
                    crtableLogoninfo = CrTable.LogOnInfo;
                    crtableLogoninfo.ConnectionInfo = crConnectionInfo;
                    CrTable.ApplyLogOnInfo(crtableLogoninfo);
                }
                cryRpt.Refresh();

                cryRpt.SetParameterValue("@voucherno", strVno);

    

Open in new window

0
Expert Spotlight: Joe Anderson (DatabaseMX)
LVL 13
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

We are looking for a software that will manage subscription services.  We have been using Excel, but it's taking off so we need something more Enterprise scaling.
Does anyone use anything they would recommend?  Ideally it would interface with SAP
0
Hi - I am setting up a SAP HANA environment based on VMware 6.5 using RHEL 7.5 VMs.

One of my VMs has a number of drives (100GB OS drive / 32GB Swap / 50GB Binaries / 32GB Shared Data / 750GB DB / 750GB Logs), 48vCPU, and 768GB RAM and resides in a number of different Datastores.

My OS and Swap files share the same disk and datastore.

When I boot my RHEL VM, it tries to create the Swap space to match the amount of RAM = 768GB which instantly fills my storage.

I want 32GB configured for Swap space.

Am I missing the obvious? Is the sudden grabbing of disk space to match the amount of RAM expected behaviour?

Any help or guidance much appreciated
0
SAP B1 - Dunning Wizard - the default reports are PLD - I'm using Crystal Reports and have created a report however I'm not sure what parameter SAP B1 uses from the dunning wizard screen to pass to Crystal.  So, does anybody know which database field I need to use for the DocEntry@ parameter?  The report runs in crystal but in the dunning wizard screen I get an error 'No matching records found' RITM ODBC -2028 Message 131-183
0
Regarding Power BI On Premise Gateway:

The Login User created on the SAP BW server\database  which will login into the server\database from the on premise gateway.

What is this configuration required of the SAP BW server\database gateway user which the Gateway will login into to create the bridge.
0
I had this question after viewing Append all database values in Parameter not bringing in all data..

I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database.  If I create an "ALL" selection and run the report it does bring in all sites.  Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.

It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing!  Not sure if this has an effect.

I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.

I have come to the end of any other solutions?

Any help is much appreciated!
0
Hi,

Our team is facing frequent disconnection while working on SAP kernel "connection partner broken" error.

WSAE:CONNRESET: connection reset by peer.

Error No: 10054

We are using IPsec tunnel between these two sites over public Internet cloud. Could you urgently suggest if there is any parameter to be checked at our firewalls (model Cisco ASA) where VPN configured.  

Anticipating favorable reply soon.

Regards

Srini
0

SAP

560

Solutions

847

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Top Experts In
SAP
<
Monthly
>