SAP

547

Solutions

833

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

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
Bootstrap 4: Exploring New Features
LVL 13
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

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 Experts,
I need installation packages for Sybase ASE 12.5, 15.0.3 & 15.5 on Linux. Could anyone send to me a download link?

Regards,
Daniel
0
requirement is calculate -Top 1% records for every location.

How to Calculate Percentile 99 for Each group at summary level in Webi report:
this below function is working fine at detail report but not working at summary report
percentile var = Percentile([CT Wait Days];0.99) In Report
Flag = =If [C Wait Days] > [percentile var]Then 1 Else 0
its working fine in detail report with percentile 99 and flag every record 1 or 0 based on output of the percentile.


please advise!
cust1_0123.xlsx
0
Dear Experts
At present we are using CRM application which is hosted on premise and it is mainly used for handling the support cases, automated email alerts and to store all the case related data, repair and maintenance data ( all data are imported  only , ie, operational users will not use instead all these to be imported  ) and tool is only used for reporting and analytics purpose only . Now that for other business process where the operational users will use in every stage  hence the need for technology solution in additional to above mainly on following business process and solution to be deployed on premises only.
1.       complete material movement tracking and capture the activities involved and automated email notifications and if the delay escalation rules .  
2.      Service, repair and maintenance  
3.      Warehouse/logistics management
4.      Inventory management
5.      Invoice management/HRMS/Vendor bills/salary # this is optional mainly 1 to 4 is important
We cannot go for cloud solutions the solution to hosted on premise.  Please suggest the ERP application that can be best suited for above should we have to evaluate Microsoft dynamics ERP AX , SAP  or any other where it to be used for operational and also for reporting and analytics . please suggest the best suited ERP or other solutions. Thanks in advance.
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
Learn Ruby Fundamentals
LVL 13
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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
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
Hello,

I need your advice please  to validate a solution for up to date  a file exchange between MarketPlace MIRAKL and SAP.
Mirakl does not give us the possibility to connect via sftp (user, mdp, port or other ).

However, If we use the CURL (client URL request library) technology to send requests and retrieve orders that are entered into our stores and repatriate them to SAP.
The connection is via https and in the script it will be used an API key that is unique and generate from our MIRAKL account. In this API key we have a user and a password, which makes the connection secure.

About security, the solution is secure (safe) or not and we advise me to implement this solution?

Best regards,
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
My client asks me to create a web application in PHP that will interact with the SAP Business One Database. They say that the database is on the cloud using the Hana database.

Also, I am trying to download the sap Hana client software package trial version but they ask for a password, I enter correct password but the software package did not download and password prompt again appear.

Please guide me how can I create a connection and start web application in PHP that can interact with SAP Business One database. Are the database queries will be the same for the Hana database while writing code in PHP. I am the beginner I am totally confused. I read a number of articles but still confused.

Expert guidance will be appreciated.
0
Announcing the Winners!
LVL 13
Announcing the Winners!

The results are in for the 15th Annual Expert Awards! Congratulations to the winners, and thank you to everyone who participated in the nominations. We are so grateful for the valuable contributions experts make on a daily basis. Click to read more about this year’s recipients!

Dear EE,

My application is using SAP file in UTF-8 format, for this purpose my application uses a a DLL “Interface_encoding.dll” to convert file into required format.

Some how , same user generates file on same PC and get the different file formats.
1) Sometime it is generated correctly in UTF-8 format
2) Sometime fie is created in UTF-8 BOM format.

Please see that we have checked for DLL registration and it was fine all the time.

Your support is required to find out the possible root cause and resolution.  

Thanks
0
Hi Anyone,

My SAP User suddenly unable to login to the system so login to SAP server to restart the system to temporary solve the issues. Found a lot of errors as in below for your kind advice.    
App Event
Event ID: 1000
Faulting application name: SCNotification.exe, version: 5.0.8239.1000, time stamp: 0x552cebe1
Faulting module name: KERNELBASE.dll, version: 6.3.9600.18666, time stamp: 0x58f32841
Exception code: 0xe0434352
Fault offset: 0x00015608
Faulting process id: 0x6f98
Faulting application start time: 0x01d411cc302080bf
Faulting application path: C:\Windows\CCM\SCNotification.exe
Faulting module path: C:\Windows\SYSTEM32\KERNELBASE.dll
Report Id: 6de281cc-7dbf-11e8-81b8-005056a12199
Faulting package full name:

Event ID: 1026
Application: SCNotification.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Net.Sockets.SocketException
   at System.Net.Sockets.Socket.DoBind(System.Net.EndPoint, System.Net.SocketAddress)
   at System.Net.Sockets.Socket.Bind(System.Net.EndPoint)
   at System.Net.Sockets.TcpListener.Start(Int32)
   at System.Runtime.Remoting.Channels.ExclusiveTcpListener.Start(Boolean)
   at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel.StartListening(System.Object)
   at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel.SetupChannel()
   at System.Runtime.Remoting.Channels.Tcp.TcpServerChannel..ctor(System.Collections.IDictionary, …
0
I want to convert an existing Sybase code to oracle?
I am very new to oracle, and don't have much knowledge on Sybase.
What approach should I follow?
0
Hi Team,

I have downloaded .rtf file from SAP by using Tcode "STAD"

How I can Analyse/Read STAD log file (.rtf format) using excel Macro?
0
sap sql connection webserices how to read
0
Running some hourly query using sybase client in my linux machine.

Getting Out of memory error

*** OutOfMemoryError ***
Request type=3


,containsODBCEscapeSequence=false,cachingHint=2,warning=null,error=null,errorMessage=null,resultsProcessor=sybase.isql.Console]
Exception in thread "Image Fetcher 0" java.lang.OutOfMemoryError: Java heap space
        at sun.java2d.loops.GraphicsPrimitiveMgr.register(Unknown Source)


Please check this error and help me.
0

SAP

547

Solutions

833

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
>