Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

SAP

508

Solutions

765

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

Dears, I have sybase replication server 15.7
I ran sysadmin hibernate_on to be able to purge queues, now I try to run sysadmin_off but the server became hung and not reactive , even after  restarting the sybase service .

please advice how can I re-active the server and finish its hibernation mode
0
[Webinar On Demand] Database Backup and Recovery
LVL 11
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Hello,
I need a macro that will move the following columns from the TC Download to the HR Region Download

D      SAP Person ID
G      Job Family
H      Job Code
I      Job Title
J      Current Salary Grade
P      Country Desc
Q      Current Planning Salary - Annual
S      Local Currency
W      Mid
AF      Equity Increase
AJ      Promotion Increase
AM      Total Budget %
AN      Total Increase
AP      %Total Increase
AQ      New Salary
AZ      New Job Code
BA      New Salary Grade
BE      New Job Family
BF      New Min
BH      New Mid
BJ      New Max
BL      Employee Bonus Eligibility
BM      FIP Rating
BQ      Select GEBP Tier Level
CF      Discipline Description
CI      SBE
CJ      SBU
DB      New Job Title
DC      Salary Notes
MACRO-TEST-2018-Global-Comp-Audit-P.xlsm
0
Dears,
kindly note I ran sp_sysmon and this is a partt from it:

Data Cache Management
---------------------

  Cache Statistics Summary (All Caches)
  -------------------------------------
                                  per sec      per xact       count  % of total
                             ------------  ------------  ----------  ----------
Large I/Os Denied due to
        Pool < Prefetch Size          0.2           0.0           9      11.8 %
        Pages Requested
        Reside in Another
        Buffer Pool                   0.4           0.1          25      32.9 %


    Total Task Switches:           5949.2         807.6      356950

  Task Context Switches Due To:
    Voluntary Yields                 16.0           2.2         960       0.3 %
    Cache Search Misses              19.4           2.6        1162       0.3 %
    Exceeding I/O batch size          0.0           0.0           0       0.0 %
    System Disk Writes                1.3           0.2          76       0.0 %
    Logical Lock Contention           0.2           0.0          10       0.0 %
    Address Lock Contention           0.0           0.0           0       0.0 %
    Latch Contention                  0.0           0.0           0       0.0 %
    Physical Lock Transition          0.0           0.0           0       0.0 %
    Logical Lock Transition           0.0           0.0           0       0.0 %
    Object Lock Transition            0.0           0.0        …
0
SAP BEX Analyser only opens Excel formatted sheet partly in Black and white instead of Full colour?
0
Dear Team,

Following is the error is received in the ASE errorlog,

Error: 12301, Severity: 20, State: 1
00:0002:00000:00211:2017/12/13 17:57:16.79 server  Internal error: the index (id = 2) and the data for row (26710892, 25) in table 'BUT000', database 4 are inconsistent; data is marked deleted but index is not. Aborting the transaction.

After that not able to connect dataserver, below is the error,

--Server is up and running but i'm getting below error Read from the server has timed out.

$isql -U -S -P
CT-LIBRARY error:
        ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.
0
Here is the solution for that question,  

select sysuser.user_name,table_name,systableperm.*
from systable,systableperm,sysuser
where stable_id=systable.table_id
and systableperm.grantee=sysuser.user_id
and sysuser.user_name='put_user_name_here'
0
Hello everyone
any way to export the SAP "ksb1" into excell ?
thanx
0
SAP BEX Analyser only opens Excel formatted sheet partly in Black and white instead of Full colour?
BEX-erro.JPG
0
After providing the user name and password , while enabling the submit button after 2sec, system throws an error as internal error (-1102) occurred [Message 131-183]
SAPB1issue.JPG
0
I am migrating from an older version to CRS 2013 where I am unable to locate the BVM.  I've gone back in the install package seeing if I missed the install section and didn't see it even in it.  In web searches it shows I should be able to locate it in:  SAP BusinessObjects BI Platform Client Tools, however unable to locate this also.
0
Keep up with what's happening at Experts Exchange!
LVL 11
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Hello Team,

We have SSF ticketing tool to send out notification, but to unknown email address when it send email it not receiving any NDR email

We have  exchange 2013 and Office365

Thanks,
Addy
0
I would like to know if there is a report I can run in SAP to show me the project codes opened per WBS and each end date. We want to monitor the opening of codes, so instead of the individual asking for the code once it has disappeared from their time sheet we want to run a report to flag up any codes due to expire in 2 weeks time then we can ensure the end date is changed.
0
dears, I use reorg rebuild index to maintain indexes on table with data lock ,

but what can I use with allpages locking table? how to maintain its indexes, then update statistics??

kindly help
0
I have replication server. REP 15.7.1
From last 2 weeks the replication delay is more.
When we check we can see some bulk insert happen and Identity_burn_max error for 2 tables.
So we just restart the thread and fixing the issue.
We need to fix it permanently.
I suspect identity_burn_max is the problem.
I checked the two tables in database. Both are empty.
Not sure why identify_burn_max error occurs for empty tables.

Is there any way to fix the issue permanently.

1. num_mutexes is greater than num_threads
2. dsi_bulk_copy is OFF -
3. sqt_max_cache_size is 20971520
4. dsi_large_xact_size is 100
5. dsi_max_xacts_in_group is 20
0
Samsung DS5014S Landline phone

I have a Samsung OfficeServ DS-5014S with the message light flashing, even though there are no messages pending  does anyone have any ideas how to reset
0
Hi

Is there any issue if we setup 'abort tran on log full' for primary database? Does sybase try to kill repagent process in case replication marker is blocking the transaction? Kindly advise.

thanks
Chan
0
We are looking to replace our current SAP systems with a new one.  We were thinking of pointing using a friendly URL to point to the database such as  prodcutionSQLDB.ACME.com  and  productionOracleDB.ACME.com instead of using DB Server name.

This way our application servers just get this FQDN to point to the database.  THis would simplify our DR planning and future migrations.

The question is, does SAP require certificates or something similar where the application servers would not be able to communicate with the DB  (SQL or Oracle).  My understanding is SQL and Oracle use username\pass to authenticate,  or does SAP rely on certificates to communicate with the DB servers?
0
This is for my web assessmet SAP S/4 Hana Sales: which steps need to be performed for existing customers to migrate to SAP S/4 HANA? enablement of digital transformation, verification of all data layers, techincal migration, implementation of additional high security measures. In my opinion there are available all the answers, but i`m not sure; without a digital transformation you cannot migrate to S/4HANA, you must verify all the data but I don`t know what all layers means; you  it will be a technical migration, and the experte say there are additional security measures implemented. I really don`t know if my answer is correct because I have multiple choises, but I don`t know the number of correct answers; Thanks a lot! Best regards, Cris!
0
Hi All,
We are about to commence a project to start the decommissioning of SAP as we have replaced it with several other pieces of software.
SAP is internally hosted and we intend to archive the data and software as we will not be migrating all of the data to the new systems.  We will also need to keep historic data in order to meet several pieces of legislation.
Below are some of the points I thought that we need to consider, however I have never undertaken such a project before.  From the below, is there anything else I should be thinking about and taking into consideration in terms of the existing SAP infrastructure, the new archiving solution and how we make the move?

Any thoughts are appreciated.

  • Scope of data to be kept in archived SAP
  • Access to the system
- Who has access and what type of access
- Everyone to have read-only access?
- Any requirements for Admin/Developer type access?
- How will Admin/Developer access be granted (fire call)?
  • Decommissioning of old SAP Hardware – How will the hard drives be destroyed or recycled bearing in mind they hold significant private and confidential data.
  • SAP still supported for several years so how do we manage patching to keep it line with PSN requirements.
0
[Webinar] Database Backup and Recovery
LVL 11
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Hello experts,
I'm quite struggling with a date-time problem at Universe (IDT 4.1 SP7)&BO Webinar (14.1.7).

Let's start with customer request:
He needs a Webi report where he can filter by prompt -date and time in separately

For example, if he filters:
Date between 01/01/2016-30/02/2016
Time between 11:00-15:00
He wants to see all data between these dates and time 11:00-15:00

The problem -
In universe -Data Foundation I'm getting from EVENTS table a date-time filed (SQL server) - for example "04:26:47 24/07/2017"
So, on the Data Foundation level (in the EVENTS table) I created 2 "calculation columns"
Date filed - "toDate(@catalog ('RC_Control')."Control.dbo"."EVENTS"."EVENT_TIME_UTC")
Time filed - "toTime(@catalog ('RC_Control')."Control.dbo"."EVENTS"."EVENT_TIME_UTC")

In the Business Layer I created 2 dimentions (date&time)that brings these calculated columns.
Their DataType -Date
On the date filed I'm getting just the date-as I need.
On the Time dimention, on the "Advanced" tab- "Edit display format"-I costumed the format as customer need - "hh:mm"
When I create a query I'm getting the "he:mm" as I need.
Now on BO Webi I created the 2 prompts and here are my problems:
Problem no. 1 : "Time" prompt - I'm getting date only (!!!!). It doesn't recognize the costume I made on the IDT.
I need it to be filtered by "hh:mm" only
Problem no.2 : when I display chosen date filter (by - userResponse("psEnter Value for date (start):") I'm still getting the …
0
I am beginner in SAP and ABAP. I must to do program with BAPI_ACC_DOCUMENT_POST which posted account 602101 to 60210101, but tax rate is 0. I have little proglem. Please help me.
0
If you have data rows like

1.  TypeA.     Control 1.  Answer 1
2.  TypeA.      Control1.  Answer2
3.  TypeA.      Control2.  Answer1
3.   TypeB.    
4.   TypeB.     Control1.  


Where you have three different drop downs
0
I have one 12U1 SLES machine in which i want to open an port no 31015 for SAP HANA but unable to.

Netstat -tulpn also not showing LISTEN to this port .

I have also tried it with Yast2 firewall advance option but dont same problem

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      2475/sshd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2169/master
tcp        0      0 0.0.0.0:51013           0.0.0.0:*               LISTEN      2341/sapstartsrv
tcp        0      0 0.0.0.0:51014           0.0.0.0:*               LISTEN      2341/sapstartsrv
tcp        0      0 0.0.0.0:1128            0.0.0.0:*               LISTEN      2295/sapstartsrv
tcp        0      0 0.0.0.0:1129            0.0.0.0:*               LISTEN      2295/sapstartsrv
tcp        0      0 :::22                   :::*                    LISTEN      2475/sshd
tcp        0      0 ::1:25                  :::*                    LISTEN      2169/master
udp     5376      0 0.0.0.0:68              0.0.0.0:*                           1308/wickedd-dhcp4


telnet IP 31015
gives keep trying then unable to reach

telnet working for other ports like ssh and 1128 etc.

please help
0
I have a Physcial Server hoste dwitH SAP ECC and BW Modules i am looking at migrating to cloud could any please advice on the best approaches to migrate to cloud considering that time is important factor (may be a image backup and restore will work) ?.

Please advice i will give points to multiple answers every one is welcome....
0
Hi all,
i have the unenviable task of updating an onliine sales portal made at least 10 years ago, and which links into a customers SAP system.

there are no problems when i am updating prices, but if i need to add items to the page, there is code i obviously need to alter:
onClick="buyItem('5247 BURN AID GEL 50G PK10','6.10', document.itemsform.box10.value)">

The question is, what and where does the "document.itemsform.box10.value" refer to, and can i just add to the box value if i am adding more items? i.e. if box11.value didnt exist, could i add that code to a new item?

thanks in advance
0

SAP

508

Solutions

765

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
>